User guide

dropprocedure[dbo].[spTrapAlert_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spSetupAlertsTrap_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spSetupAlertsTrap_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryAlertLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryAlertLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogData_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogData_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryObjectVersion_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryObjectVersion_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetSQL_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetSQL_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetWaittypeDesc_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetWaittypeDesc_20]
USEmsdb
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[sp_sentry_mail]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[sp_sentry_mail]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[sp_sentry_mail_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[sp_sentry_mail_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryEmails_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryEmails_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetBlockInfo_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetBlockInfo_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spGetBlockInfo_Pre8sp3]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spGetBlockInfo_Pre8sp3]
GO
BEGINTRANSACTION
DECLARE@JobIDBINARY(16)
DECLARE@ReturnCodeINT
SQL Sentry Quick Start 43
©2015 SQL Sentry. All Rights Reserved.