Saturday, February 25, 2012

AUDIT all commands performed by Privileged Users on SQL 2000/2005

Is there any way to audit all commands executed by people with Sysadmin
access on SQL 2000 and SQL 2005 ? Any answer or suggestion would be greatly
appreciated.Hi
On SS2005 you are availalble to create a trigger on server/database level.
For moree details please refer to the BOL
"DDLooks" <DDLooks@.discussions.microsoft.com> wrote in message
news:893A8BF5-2298-4446-AC66-93840B922325@.microsoft.com...
> Is there any way to audit all commands executed by people with Sysadmin
> access on SQL 2000 and SQL 2005 ? Any answer or suggestion would be
> greatly
> appreciated.

No comments:

Post a Comment