Auditing SQL Server 2005 Standard Database on Inse

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources