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 |
|
JustaDBA
Starting Member
3 Posts |
 Posted - 2009-04-24 : 22:33:52
|
| Hi,New to the forum. We are running SQL Server 2005 Standard and I was wondering if there was a way to capture DML commands to a table without running a trace. Thanks in advanced for your help... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-24 : 23:06:46
|
| Yes with Triggers. |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-04-25 : 00:42:22
|
| How can capture DDL Commands?? Is any possible way?Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceled |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-25 : 01:53:57
|
Yes. Use server triggers.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
JustaDBA
Starting Member
3 Posts |
Posted - 2009-04-27 : 21:26:27
|
| Thanks everyone for your replies...To answer a few questions, we can't use a trace because we are trying to capture multiple DML commands from multiple instances across our farm. We push out code from a central server to our farm of 800 DBs. We want to be able to capture these commands during our deployment as a type of audit to see where we go wrong during the deployments. Using a trace is too disconnected. We can't do triggers because we need to capture and log the Select statements. We've looked into having all the ddl run getting service brokered to all the DBs but somebody wants DML too. |
|
|
|
JustaDBA
Starting Member
3 Posts |
Posted - 2009-04-30 : 23:07:38
|
| we found the fix...create your own trace using a c# objectMicrosoft.SqlServer.Management.Trace; |
|
|
|
|
|
|
Capturing DML without using a trace