HI all,
I am using SQL Server 2012.
I Need to create a Single Trigger From First_DataBase TableA to Second_DataBase TableB
When ever any modification done on TableA it'll affect the TableB
In this concept i am using Two DataBase
Whenever a row is inserted or updated or deleted in Table A, it should be affect the Table B.
Same Columns Name for TableA and TableB
How to handle this from a single trigger?
In this concept DataBaseA having 40 tables, Just i am creating a New Database as DataBaseB, I am going to copy all the 40 tables from DataBaseA to DataBaseB and i am renaming the 40 Tables, After that i am going to Use Trigger Concept for INSERT\UPDATE\DELETE, and Whenever a row is inserted or updated or deleted in Table A (DataBaseA) , it should be affect the Table B(DataBaseB) ...... Any body having Idea how to do this?

Rahul PrajapatPosted Jun 19, 2015, 1:18 AM