Uninstalling SQL Lock
Published 05 January 2016
To uninstall the SQL Lock beta, you first need to run a SQL script to remove the SQL Lock functionality from the server. After you run the script, you can uninstall the add-in.
If you don't run the uninstall script, any locked objects will stay locked until you either reinstall the add-in and unlock them, or run the unlock SQL for each object.
Uninstall script
-- This script removes the SQL Lock functionality from the server.
-- It will also unlock all objects on the server.
USE [RedGate]
GO
IF OBJECT_ID('[SQLLock].[LockObject]') IS NOT NULL
DROP PROCEDURE [SQLLock].[LockObject]
GO
IF OBJECT_ID('[SQLLock].[UnlockObject]') IS NOT NULL
DROP PROCEDURE [SQLLock].[UnlockObject]
GO
IF OBJECT_ID('[SQLLock].[IsObjectLocked]') IS NOT NULL
DROP PROCEDURE [SQLLock].[IsObjectLocked]
GO
IF OBJECT_ID('[SQLLock].[GetLockedObjects]') IS NOT NULL
DROP PROCEDURE [SQLLock].[GetLockedObjects]
GO
IF EXISTS (SELECT * FROM sys.server_triggers WHERE name = 'RedGate_CheckForLockedObjectOnDDLChange')
DROP TRIGGER [RedGate_CheckForLockedObjectOnDDLChange] ON ALL SERVER
GO
IF OBJECT_ID('[SQLLock].[LockedObjects]') IS NOT NULL
DROP TABLE [SQLLock].[LockedObjects]
GO
IF (SCHEMA_ID('SQLLock') IS NOT NULL)
DROP SCHEMA [SQLLock]
GO
USE [master]
GO
ALTER DATABASE RedGate SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE [RedGate]
GO 
