Post reply

SQL Server 6.5 - SQL TRace keeps stopping

  • July 29, 2002 at 8:41 am

    #101209

    Hello,

    On our SQL server 6.5 boxes, SQL Trace is randomly stopping. It would be great if there were a script/scheduled task that exists that would check to see of SQL Trace is running at regular intervals, and if

    it is not running, that script would start it. One resolution I've heard of would be to schedule a small select statement to run every 3 or so minutes to keep the trace alive, but I'm not sure how to write a script to do that.

    Thanks

  • July 29, 2002 at 10:29 am

    #433549

    I'd write a stored procedure that creates a temp table and fills it with the output of sp_who. Or query sysprocesses and look for the sqltrace application.

    If it's not found, there is a stored procedure (can't remmeber it) to run a server side trace. Execute it.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply