|
|
Here in the steps to stop the traces:_
Step 1: Find out what are all running
select * FROM :: fn_trace_getinfo(default)
Step 2: Stop them by passing trace id and status
sp_trace_setstatus 3, 0
go
sp_trace_setstatus 3, 2
|
|
||||||
|
|
Syntax
sp_trace_setstatus [ @traceid = ] trace_id , [ @status =
] status
|
|
||||||
|
|
|
|
Ads
02 June 2015
To stop multiple traces on server
Subscribe to:
Post Comments (Atom)
-
ERROR: report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the o...
-
Error messages: · The process could not execute 'sp_repldone/sp_replcounters' on ' SCKNLSSI '. (Source:...
-
Error Message: Replication-Replication Distribution Subsystem: agent DBA\DBA-EPDW-EPDW-DB6C\DB6C-5 failed. The subscription(S) have been...
No comments:
Post a Comment