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
 SQL Server Administration (2005)
 Auditing SQL Server 2005 Standard Database on Inse

Author  Topic 

raguyazhin
Posting Yak Master

105 Posts

Posted - 2013-02-11 : 02:17:14
Hi

I have doubt about data Auditing in SQL Server 2005 EE.
Is SQL Server 2005 has any default data Auditing for DML Operations?

Kindly Suggest me.

--
Ragu

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-12 : 01:55:25
If your intention is to capture all the dml operations - either execute a trace or explore some of the suggestions made in articles. Could you specify your objective?

There is a default trace , but that won't give you a list of dml operations . There are many other events which you can check: http://www.sqlserver-dba.com/2012/04/sql-server-default-trace-faq.html

Some other approaches to obtaining the last DML operations are in this article: http://www.sqlserver-dba.com/2012/09/sql-server-last-dml-operation.html



Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -