Track changes in sql

1

Hi,
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?

Thanks
subha

2

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

3

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