SQL 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lwmccksg - 26 Nov 2007 01:44 GMT

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?

Reply to this Message

Ben Nevarez - 26 Nov 2007 02:01 GMT

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

> 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?

Reply to this Message

lwmccksg - 26 Nov 2007 02:27 GMT

thanks for your prompt answer.

> Hello,
>
[quoted text clipped - 8 lines]
> > 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?

Reply to this Message

bass_player [SBS-MVP] - 26 Nov 2007 04:01 GMT

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

> Hello,
>
[quoted text clipped - 9 lines]
>> setting
>> in the SQL 2000 database. Any GUI screen for doing this audit setting?

Reply to this Message

Erland Sommarskog - 26 Nov 2007 23:08 GMT

> 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?

Nothing built-in, but there are third-party products that can help
you. Some work with triggers like ApexSQL's SqlAudit. Other work from
the transaction log. Lumigent has such a tool, for instance.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Sean McCown - 27 Nov 2007 15:40 GMT

Just be really careful when doing your evals for the auditing tools. A lot
of them don't perform well at all. So really put them through the ringer
when you're looking at them.

> > 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
[quoted text clipped - 3 lines]
> you. Some work with triggers like ApexSQL's SqlAudit. Other work from
> the transaction log. Lumigent has such a tool, for instance.

Reply to this Message

Erland Sommarskog - 27 Nov 2007 23:12 GMT

> Just be really careful when doing your evals for the auditing tools. A
> lot of them don't perform well at all. So really put them through the
> ringer when you're looking at them.

Through the years, I've seen many posts where people apparently have
been working on their own home-grown auditing solutions. I wonder how
well they perform....

Signature

Reply to this Message