-
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
-
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
-
Forum Rules
|
|