DECLARE @PROCNAME VARCHAR(500) DECLARE CUR CURSOR FOR SELECT [NAME] FROM SYS.OBJECTS
WHERE TYPE IN (N'SQ') AND NAME LIKE 'SQLQUERYNOTIFICATIONSERVICE%' OPEN CUR FETCH NEXT FROM CUR INTO @PROCNAME WHILE @@FETCH_STATUS = 0 BEGIN BEGIN TRY EXEC ('DROP QUEUE [' + @PROCNAME+']') FETCH NEXT FROM CUR INTO @PROCNAME END TRY BEGIN CATCH FETCH NEXT FROM CUR INTO @PROCNAME END CATCH END CLOSE CUR DEALLOCATE CUR
No comments:
Post a Comment