xp_sqltrace

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