SQL Server 2008 Audit

Question

Post reply

SQL Server 2008 Audit

chewychewy

Hall of Fame

Points: 3126
More actions
May 14, 2013 at 1:12 am

#277721

Hi Guys,
I wish to audit all the activities performed by users having sysadmin role.
Is there any straight foward way to do it?
Can't find such options under Server Audit or Database Audit specifications.
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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

raadee SSC Eights! Points: 881 More actions · Answer 1

This thread might give you an idea on how:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/2d3ba502-b8e3-4270-b592-27ec2ed1140b/

chewychewy Hall of Fame Points: 3126 More actions · Answer 2

Hi,

Seems like we can't audit DDL executed only by SYSADMIN.

Anyone who done this before can confirm?

thanks!

tarun.pant 45282 Newbie Points: 9 More actions · Answer 3

Hi,

Could you elaborate that what are the DDL commands that you want to audit. To audit the activities of any users having sysadmin role there are many cost-effective third party tools available in the market which can perform such operations in an excellent and quick way. If you want then I can name a few of these which can perform such operations.