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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Capture the DML stmts run against a table in db

Author  Topic 

veda_sqldba
Starting Member

6 Posts

Posted - 2010-09-03 : 05:07:49
Hi,
My requirement is to capture all the DML action perfomed on a table ina particular database in all 10 minutes.I have read about tools like "logreader"/"apec" but i am not allowed to install any 3rd party tools in the system holding the server,Please suggest

VEDA

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-09-03 : 09:22:09
Profiler - http://msdn.microsoft.com/en-us/library/ms187929(v=SQL.90).aspx

sp_trace_create - http://msdn.microsoft.com/en-us/library/ms190362(v=SQL.90).aspx
Go to Top of Page
   

- Advertisement -