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