Re: SQL 2000



You can also use the C2 Audit mode on the server level which will apparently
be resource intensive

"Ben Nevarez" <BenNevarez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A6104562-E94F-472F-A81F-412016B20B66@xxxxxxxxxxxxxxxx

Hello,

If you are talking about auditing data changes you can audit any field on
any table and usually that it is accomplished by using triggers.
Unfortunatelly there is no GUI screen to do that.

Ben Nevarez
Senior Database Administrator
AIG SunAmerica



"lwmccksg" wrote:

I would like to find out what are the fields that can be audited by
setting
in the SQL 2000 database. Any GUI screen for doing this audit setting?



.