sqltabledependency trigger on my table “locks” all upcoming DML operations about monitor-table-change-with-sqltabledependency HOT 4 OPEN

PRINT 'Starting Killing Services'

DECLARE @name VARCHAR(5000) 

DECLARE db_services_cursor CURSOR FOR 
SELECT [name] FROM sys.services 
WHERE service_id > 3

OPEN db_services_cursor  
FETCH NEXT FROM db_services_cursor INTO @name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @name)
    EXEC('drop service [' + @name + ']')
    FETCH NEXT FROM db_services_cursor INTO @name 
END 

CLOSE db_services_cursor  
DEALLOCATE db_services_cursor 

PRINT 'Ended'



PRINT 'Starting Killing Contracts'

DECLARE @contract_name VARCHAR(5000) 

DECLARE db_contract_cursor CURSOR FOR 
SELECT [name] FROM sys.service_contracts where service_contract_id > 6

OPEN db_contract_cursor  
FETCH NEXT FROM db_contract_cursor INTO @contract_name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @contract_name)
    EXEC('drop contract [' + @contract_name + ']')
    FETCH NEXT FROM db_contract_cursor INTO @contract_name 
END 

CLOSE db_contract_cursor  
DEALLOCATE db_contract_cursor 

PRINT 'Ended'


PRINT 'Starting Killing Triggers Procs'

DECLARE @triggers_name VARCHAR(5000) 

DECLARE db_triggers_cursor CURSOR FOR 
SELECT name FROM sys.triggers WHERE type = 'TR' and name LIKE 'tr_dbo%_Sender'

OPEN db_triggers_cursor  
FETCH NEXT FROM db_triggers_cursor INTO @triggers_name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @triggers_name)
    EXEC('drop trigger [' + @triggers_name + ']')
    FETCH NEXT FROM db_triggers_cursor INTO @triggers_name 
END 

CLOSE db_triggers_cursor  
DEALLOCATE db_triggers_cursor 

PRINT 'Ended'



PRINT 'Starting Killing Stored Procs'

DECLARE @storedprocs_name VARCHAR(5000) 

DECLARE db_storedprocs_cursor CURSOR FOR 
SELECT [name] from sysobjects where type = 'P' and category = 0 and name LIKE '%QueueActivationSender'

OPEN db_storedprocs_cursor  
FETCH NEXT FROM db_storedprocs_cursor INTO @storedprocs_name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @storedprocs_name)
    EXEC('drop PROCEDURE [' + @storedprocs_name + ']')
    FETCH NEXT FROM db_storedprocs_cursor INTO @storedprocs_name 
END 

CLOSE db_storedprocs_cursor  
DEALLOCATE db_storedprocs_cursor 

PRINT 'Ended'


PRINT 'Starting Killing Message Types'

DECLARE @messagetype_name VARCHAR(5000) 

DECLARE db_messagetype_cursor CURSOR FOR 
SELECT [name] FROM sys.service_message_types where message_type_id > 14

OPEN db_messagetype_cursor  
FETCH NEXT FROM db_messagetype_cursor INTO @messagetype_name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @messagetype_name)
    EXEC('drop MESSAGE TYPE [' + @messagetype_name + ']')
    FETCH NEXT FROM db_messagetype_cursor INTO @messagetype_name 
END 

CLOSE db_messagetype_cursor  
DEALLOCATE db_messagetype_cursor 

PRINT 'Ended'




PRINT 'Starting Killing Queues'

DECLARE @queue_name VARCHAR(5000) 

DECLARE db_queue_cursor CURSOR FOR 
SELECT [name] FROM sys.service_queues where is_ms_shipped = 0

OPEN db_queue_cursor  
FETCH NEXT FROM db_queue_cursor INTO @queue_name  

WHILE @@FETCH_STATUS = 0  
BEGIN  
	PRINT ('Current Name: ' + @queue_name)
    EXEC('drop QUEUE [' + @queue_name + ']')
    FETCH NEXT FROM db_queue_cursor INTO @queue_name 
END 

CLOSE db_queue_cursor  
DEALLOCATE db_queue_cursor 

PRINT 'Ended'