Darren Maginnis darrenmaginnis

## Deadlock_Retry.sql
DECLARE @Retry INT;
SET @Retry = 3;

SET DEADLOCK_PRIORITY LOW;
WHILE (@Retry > 0)
BEGIN
	BEGIN TRY

		--Code that can deadlock


## DROP_Procedures_Functions_User_Types_and_Views.sql
-- Stored Procedures
PRINT 'Dropping Stored Procedures'
DECLARE @sqlDropProcedure NVARCHAR(MAX) = N'';
SELECT  @sqlDropProcedure += 'DROP PROCEDURE [' + OBJECT_SCHEMA_NAME(object_id) + '].[' + name + ']; '
FROM sys.procedures
WHERE is_ms_shipped = 0
ORDER BY OBJECT_SCHEMA_NAME(object_id), name;

EXEC sp_executesql @sqlDropProcedure;
	DECLARE @Retry INT;
	SET @Retry = 3;

	SET DEADLOCK_PRIORITY LOW;
	WHILE (@Retry > 0)
	BEGIN
	BEGIN TRY

	--Code that can deadlock
	-- Stored Procedures
	PRINT 'Dropping Stored Procedures'
	DECLARE @sqlDropProcedure NVARCHAR(MAX) = N'';
	SELECT @sqlDropProcedure += 'DROP PROCEDURE [' + OBJECT_SCHEMA_NAME(object_id) + '].[' + name + ']; '
	FROM sys.procedures
	WHERE is_ms_shipped = 0
	ORDER BY OBJECT_SCHEMA_NAME(object_id), name;

	EXEC sp_executesql @sqlDropProcedure;