-- **********************************
-- ***  Detener todas las Trazas  ***
-- **********************************
--
-- GuilleSQL - Un portal sobre Microsoft SQL Server en Castellano
-- https://guillesql.es
--

declare @tmp_traceid int

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\long_running_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\long_running_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\blocks_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\blocks_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\deadlocks_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\deadlocks_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\hash_warning_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\hash_warning_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\sort_warnings_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\sort_warnings_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\objects_created_altered_deleted_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\objects_created_altered_deleted_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END

IF EXISTS(select traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\audit_server_operation_%')
BEGIN
   select @tmp_traceid = traceid from fn_trace_getinfo(0) where cast(value as varchar(1000)) like '%\audit_server_operation_%'
   exec sp_trace_setstatus @tmp_traceid, 0
   exec sp_trace_setstatus @tmp_traceid, 2
END