User guide
10.3 Uninstalling SQL Sentry
SQL Sentry can be uninstalled through the Control Panel in Windows. When you uninstall the SQL
Sentry Client or Monitoring Service, the associated program files will be removed. User preferences
stored in the registry, and the SQL Sentry Database will not be deleted.
Additionally, the .NET Framework files will not be removed when uninstalling SQL Sentry. This can be
accomplished using Add/Remove Programs in the Control Panel.
REMOVING WATCHED SERVER OBJECTS
If you have stopped watching a SQL Server instance with SQL Sentry, and have no plans to watch it
again in the near future, scripts are provided to automate the process of removing the objects SQL
Sentry places on a watched server. Click the appropriate link below to view the script.
SQL Server 2000 instances
SQL Server 2005 and above instances
10.3.1 Object Removal Script for Watched 2000 Servers
Object Removal Script for Watched 2000 Servers
USEmsdb
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[sp_sentry_mail]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[sp_sentry_mail]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[sp_sentry_mail_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[sp_sentry_mail_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryEmails_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryEmails_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetBlockInfo_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetBlockInfo_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetBlockInfo_Pre8sp3]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetBlockInfo_Pre8sp3]
GO
BEGINTRANSACTION
DECLARE@JobIDBINARY(16)
DECLARE@ReturnCodeINT
SELECT@ReturnCode=0
--Deletethejobwiththesamename(ifitexists)
SELECT@JobID=job_id
FROMmsdb.dbo.sysjobs
SQL Sentry Quick Start 40
©2015 SQL Sentry. All Rights Reserved.