Re: SQL 2000



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.

"Erland Sommarskog" wrote:

lwmccksg (lwmccksg@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

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

.



Relevant Pages

  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
    ... I hope MS fix this livelock problem in the next service pack. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: IDENT_CURRENT and empty table
    ... >> And there is no definition what the result will be after fixing the bug. ... Books Online for 2005 is wrong and will be updated. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Rolling up spans without breaks between them
    ... CREATE TABLE periods (start datetime NOT NULL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)