Monday, March 26, 2012

How to change security audit on SQL server programatically

Right now, the default security auditing is set to none when i go through
Enterprise Manager.
I would like to change it to all. How can I do so programatically ?Hi,
You need to edit the registry key.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer]
Change the value for registry key AuditLevel to 3.
Note: Editing the registry key is not a good practice and it is risky as
well.
Thanks
Hari
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:esZOB$5aFHA.720@.TK2MSFTNGP15.phx.gbl...
> Right now, the default security auditing is set to none when i go through
> Enterprise Manager.
> I would like to change it to all. How can I do so programatically ?
>sql

No comments:

Post a Comment