I need to enable c2 auditing on our SQL SERVER 2000 database, but it's not
working.
I set the parameters:show advanced options and 'c2 audit mode' to 1. I
restarted SQL server. I am a DBA,so my privileges should be appropriate. I
went into SQL analyzer and ran a few DML statements. I am not seeing an audit
file under the mssql serverdata directory. Somethings missing and I do not
know what it is.
I would appreciate any suggestions you may have.
Did you run RECONFIGURE?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Leida" <Leida@.discussions.microsoft.com> wrote in message
news:3B04E334-80AA-475E-B677-728B1932A173@.microsoft.com...
>I need to enable c2 auditing on our SQL SERVER 2000 database, but it's not
> working.
> I set the parameters:show advanced options and 'c2 audit mode' to 1. I
> restarted SQL server. I am a DBA,so my privileges should be appropriate. I
> went into SQL analyzer and ran a few DML statements. I am not seeing an audit
> file under the mssql serverdata directory. Somethings missing and I do not
> know what it is.
> I would appreciate any suggestions you may have.
Showing posts with label notworking. Show all posts
Showing posts with label notworking. Show all posts
Sunday, March 11, 2012
auditing sql server
Subscribe to:
Posts (Atom)