Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Table replica

Author  Topic 

rohitmathur11
Yak Posting Veteran

77 Posts

Posted - 2010-01-18 : 00:54:53
I need to create replica of one table .Like when ever row insert in to main table same data will go into replica table or row updated same row will update on second table also ..i am using trigger for this ..how to identify insert or update in this ..?

rohitmathur11
Yak Posting Veteran

77 Posts

Posted - 2010-01-18 : 01:10:56
I am having table1 ...what ever dml we are doing on table1 ..should go to table2 also.. like insert..update and update ..how to write scuch trigger ...?
Go to Top of Page
   

- Advertisement -