Pinned

1. Deadlock retry logic Deadlock retry logic

   1

   DECLARE @Retry INT;

   2

   SET @Retry = 3;

   3

   4

   SET DEADLOCK_PRIORITY LOW;

   5

   WHILE (@Retry > 0)

2. DROP all user created Stored Procedu... DROP all user created Stored Procedures, Functions, User Types, and Views

   1

   -- Stored Procedures

   2

   PRINT 'Dropping Stored Procedures'

   3

   DECLARE @sqlDropProcedure NVARCHAR(MAX) = N'';

   4

   SELECT  @sqlDropProcedure += 'DROP PROCEDURE [' + OBJECT_SCHEMA_NAME(object_id) + '].[' + name + ']; ' 

   5

   FROM sys.procedures