MS SQL Audit 1

[keithfg]

Hi,

I would like to create an audit on a specific table which captures the DML statement (not the results) executed by any user. Is there a system variable which stores such data? I am currently using MSSQL 7 and MSSQL 2000.

Thanks

Keith

 

[hmckillop]

You can do this using SQL auditing via trace files. A very good article exists on the Microsoft website, it may seem a bit of an overkill but will do exactly what you want.

http://www.microsoft.com/technet/security/prodtech/dbsql/sql2kaud.mspx

"I'm living so far beyond my income that we may almost be said to be living apart

 

[keithfg]

Thanks for the link. Does this also apply to SQL 7?

 

[hmckillop]

As far as I know, SQL 2000 is C2 compliant and not SQL 7, but I think all the trace options work the same. Might be a different proc to get things to run on startup of SQL Server, but from what i recall it shouldnt differ too much


"I'm living so far beyond my income that we may almost be said to be living apart