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.
| Author |
Topic |
|
gvphubli
Yak Posting Veteran
54 Posts |
 Posted - 2003-06-11 : 05:11:10
|
| 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 DBA = -http://www.geocities.com/gvphubli/ |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2003-06-11 : 06:32:02
|
| It sounds like you're trying to reinvent the wheel to avoid a (potentially) difficult task, but what you are asking sounds even more involved.Look up log shipping in the BOL.-------Moo. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-06-11 : 08:51:35
|
| The sql profiler can record only T-SQL or SP's and even filter by name and it allows you to save it to a sql script. Anyone know what the automation object for sql profiler is called? I thinking gvphubli could use it to save the traces every two hours and run it on the second server.However, I agree with mr_mist why not log shipping????? |
|
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2003-06-12 : 23:49:11
|
| OK guys I will take ur suggestions and try log shipping...- = Cracky DBA = -http://www.geocities.com/gvphubli/ |
|
|
|
|
|
|
How to get INSERT & UPDATE statements??