SQLTeam.com | Weblogs | Forums

Track changes in sql


I have Web application connected with sqlserver1 having thousands of tables and hundreds of fields in it. want to replicate the changes into staging server.

currently the insert/update trigger has been implemented to find the tables undergoes changes. can anyone please help to do it in effective manner?



One option is to log ship the database to the second server. There are other forms of replication that might also benefit you.


Which edition of SQL Server are you using? And which version?