Results 1 to 2 of 2

Thread: xp_sqltrace

  1. #1
    Andy Robbins Guest

    xp_sqltrace

    I have started a xp_sqltrace process in a proc to log all activity to a
    file. I am able to pause the trace but the following command should stop
    the trace but is not :

    xp_sqltrace stop, @traceid = 0

    xp_sqltrace stop, @traceid = <traceid>

    xp_sqltrace stop

    exec master..xp_sqltrace stop, <traceid>

    I am not able to access to log file until I shut down Sql Server


    Please help

    arobbins@alservices.com


  2. #2
    Andy Robbins Guest

    xp_sqltrace (reply)

    On 6/24/98 9:20:41 AM, Andy Robbins wrote:
    > I have started a xp_sqltrace process in a proc to log all activity to
    > a
    file. I am able to pause the trace but the following command should
    > stop
    the trace but is not :

    xp_sqltrace stop, @traceid =
    > 0

    xp_sqltrace stop, @traceid = <traceid>

    xp_sqltrace stop

    exec

    Andy,

    I have had a similar experience using 6.5 sp 3.
    I exec xp_sqltrace with trace and stop options in stored procedures.
    I have had success by always specifying the value of the traceid in the stop
    option.

    Good Luck





    > master..xp_sqltrace stop, <traceid>

    I am not able to access to log file
    > until I shut down Sql Server


    Please help

    arobbins@alservices.com


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •