How to get INSERT & UPDATE statements??

[gvphubli]

Hi guys,
Anybody knows how to get the INSERT, UPDATE & DELETE statements that run on the server. I want to collect all the statements and run them on the other database(replica) on 2 hourly basis. I know there is replication but its difficult to set and manage.

thanks...


Cracky -= Developer/DBA =-
visit :

http://www.geocities.com/gvphubli

 

[pascalsql]

The only possible way would be to set a trace in the profiler (or third party tools) and extract the queries. But it will turn out to be much more complicated than replication.

Consider instead:
- Implement a trigger
- Encapsulate the changes in proc and deny access to anyone else
- Search for 'Replication' in BOL :-(