Is there any log that catches all querys in SQL Server 2000???
Full problem (in slanish): http://foro.hackhispano.com/showthread.php?t=28980

Thanks

Josechu (josechu.c (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

To add to Erland's response, here are some additional info and tips for
setting up the SQL Trace.

http://weblogs.sqlteam.com/dang/arch...-Profiler.aspx

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Josechu" <josechu.c (AT) gmail (DOT) com> wrote