best auditing option

Question

best auditing option

Pyman

SSChampion

Points: 13830
More actions
October 6, 2011 at 11:24 pm

#249020

what is the best auditing option available for SQL Server 2008.
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

SQLArcher SSC Eights! Points: 950 More actions · Answer 1

In SQL Server 2008 the best option for auditing will be Server and Database Audit Specifications in my opinion as it provides some level of flexibility.

You can read more about this at:

http://msdn.microsoft.com/en-us/library/cc280386.aspx

http://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx