Posted by Erland Sommarskog on 01/13/08 14:22

Josechu (josechu.c@gmail.com) writes:
> Is there any log that catches all querys in SQL Server 2000???

You would need to set up a trace for this. While you can use Profiler,
it's better to use a server-side trace for any wide-scale auditing.

If you are only looking for operations that changes the database, you
can find out with a log reader - provided that you are running in
full recovery that is. Log readers are third-party tools. Some vendors
are Lumigent, Log PI and ApexSQL.



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

• Next in forum: Re: Queries Log on SQL Server 2000 ???
• Prev in forum: Queries Log on SQL Server 2000 ???
• Thread view: Re: Queries Log on SQL Server 2000 ???

[Reply to this message]