Scheduling SQL Profiler

microsoft.public.sqlserver.programming

30 Jun 2005 10:19 PM

Lontae Jones

Hello I would like to schedule my trace QSTRC which has the following events
daily from 8-5:
Locks
-Lock:Deadlock
-Lock:Escalation
Stored Procedures
-SP:StmtStarting
TSQL
SQL:BatchStarting

1 Jul 2005 2:48 AM

Ravi

You can use sql trace stored procedures. It will not use the scheduler,
instaed it will be part of server side process. Refer BOL for tract stored
procedures.

Note : Prcedures are different between SQl 7 and SQl 2000

--
Thanks & Rate the Postings.
-Ravi-

Show quote

"Lontae Jones" wrote:

> Hello I would like to schedule my trace QSTRC which has the following events
> daily from 8-5:
> Locks
> -Lock:Deadlock
> -Lock:Escalation
> Stored Procedures
> -SP:StmtStarting
> TSQL
> SQL:BatchStarting
>