log all queries

Hi there,
Is it possible in SQL 2000 to log all queries against a database? Thank
you, Calin
Hello,
Please use Profiler or Server side tracing to log all the TSQL/stored
procedures ran on a server. This is little bit resouce intensive and eat lots
of disk space. So it is good to monitor while log.
Thanks
Hari
"Tester" wrote:

> Hi there,
> Is it possible in SQL 2000 to log all queries against a database? Thank
> you, Calin
>
>
|||Yes. You can use SQL Server Profiler to capture event information. You can
start with the following event classes:
Stored Procedures -> RPC:Completed
and
TSQL -> BatchCompleted
Look for SQL Server Profiler in Books Online for details. Also, depending on
the number of events and the load of the SQL Server, profiler may have an
impact in performance, since the events captured are being logged.
"Tester" wrote:

> Hi there,
> Is it possible in SQL 2000 to log all queries against a database? Thank
> you, Calin
>
>