User guide

COMMITTRANSACTION
GOTOEndSave
QuitWithRollback:
IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION
EndSave:
GO
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[spTrapAlert_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)
dropprocedure[dbo].[spTrapAlert_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[spSetupAlertsTrap_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=
1)
dropprocedure[dbo].[spSetupAlertsTrap_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[SQLSentryAlertLog_20]')andOBJECTPROPERTY(object_id,N'IsUserTable')=
1)
droptable[dbo].[SQLSentryAlertLog_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[SQLSentryLogData_20]')andOBJECTPROPERTY(object_id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogData_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[SQLSentryObjectVersion_20]')andOBJECTPROPERTY(object_id,
N'IsUserTable')=1)
droptable[dbo].[SQLSentryObjectVersion_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[fnGetSQL_20]')andOBJECTPROPERTY(object_id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetSQL_20]
ifexists(select*fromsys.objectswhereobject_id=object_id(N'[dbo].
[fnGetWaittypeDesc_20]')andOBJECTPROPERTY(object_id,
N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetWaittypeDesc_20]

10.4 Watched Server Objects
PERFORMANCE ADVISOR WATCHED SERVER OBJECTS
When a SQL Server instance is watched by SQL Sentry Performance Advisor, the below objects are
placed on the target server. To remove these objects, see the Uninstalling SQL Sentry topic.
TABLES (MSDB):
SQLSentryObjectVersion_20
SQL Sentry Quick Start 50
©2015 SQL Sentry. All Rights Reserved.