Queries Log on SQL Server 2000 ???

Queries Log on SQL Server 2000 ???

am 13.01.2008 13:04:36 von Josechu

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

Re: Queries Log on SQL Server 2000 ???

am 13.01.2008 15:22:46 von Erland Sommarskog

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/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx

Re: Queries Log on SQL Server 2000 ???

am 13.01.2008 16:14:11 von Dan Guzman

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

http://weblogs.sqlteam.com/dang/archive/2007/12/16/Avoid-Cau sing-Problems-with-Profiler.aspx

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Josechu" wrote in message
news:49d00b83-5741-4c2a-84f1-02850b029dde@f47g2000hsd.google groups.com...
> 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