dbo.QBM_PIndicatorChange

1     create   procedure QBM_PIndicatorChange (@Enable bit) as begin declare @ret int = 0 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
2() declare @CheckInterval_VI_DB varchar(64) = '00:00:10.5'  SET XACT_ABORT OFF BEGIN TRY if @Enable = 0  begin  if exists (select top 1 1 from sys.tables
3 t join sys.triggers tr on tr.parent_id = t.object_id where t.name = 'DialogDatabase' and tr.name = 'QBM_TUIndicator474488' and tr.is_disabled = 0 )  and
4 exists (select top 1 1 from sys.tables t join sys.triggers tr on tr.parent_id = t.object_id where t.name = 'DialogDatabase' and tr.name = 'QBM_TUIndicator474488'
5 ) begin  if @@TRANCOUNT > 0 begin raiserror ('#LDS#Disabling indicator trigger requires transaction-free state.|', 18, 1) with nowait goto EndLabel end
6 alter table DialogDatabase disable Trigger QBM_TUIndicator474488  waitfor delay @CheckInterval_VI_DB  end   end else  begin  if not exists (select top
7 1 1 from sys.foreign_keys fk with (readpast) join sys.objects c with (readpast) on c.object_id = fk.parent_object_id join sys.objects p with (readpast
8) on p.object_id = fk.referenced_object_id where fk.type = 'F' and c.type in( 'U' ) and p.type in( 'U' ) and fk.is_disabled = 1 ) and not exists (select
9 top 1 1 from sys.objects o with (readpast) join sys.triggers t with (readpast) on o.object_id = t.parent_id where o.type in( 'U' ) and t.is_disabled =
10 1 and t.name != 'QBM_TUIndicator474488' )  and exists (select top 1 1 from sys.objects o with (readpast) join sys.triggers t with (readpast) on o.object_id
11 = t.parent_id where o.type in( 'U' ) and t.is_disabled = 1 and t.name != 'QBM_TUIndicator474488' and o.name = 'DialogDatabase' )  and exists (select top
12 1 1 from sys.tables t join sys.triggers tr on tr.parent_id = t.object_id where t.name = 'DialogDatabase' and tr.name = 'QBM_TUIndicator474488' ) begin
13 alter table DialogDatabase enable Trigger QBM_TUIndicator474488 end  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (@Rethrow, 18
14, 1) WITH NOWAIT END CATCH endLabel: return @ret end 
15