I'm not sure if this available in SP2, but look in BOL for
sp_trace_create and sp_trace_setstatus. These could be run by the SQL
agent at the times they want.

Regards,
Wes


-----Original Message-----
From: Paul Schlieper
[mailto:mssqldba-ezmlmshield-x32381225.[Email address protected]
Sent: Thursday, April 28, 2005 2:50 PM
To: LazyDBA Discussion
Subject: Profiler question

Is it possible to start a Profiler trace in TSQL/command shell? Using
SQL 2K sp2 (If I read correctly, it is possible in TSQL with sp3).

Users want a trace enabled on the first business day of the month
(beginning a lot earler than I arrive and ending later than I stay).

P



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page