Sentry Sentry 2.0 Guide de l'utilisateur télécharger pdf (Page 50)

COMMITTRANSACTION

GOTOEndSave

QuitWithRollback:

IF(@@TRANCOUNT>0)ROLLBACKTRANSACTION

EndSave:

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')=

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')=

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

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 56

Pas de commentaire

Sentry Sentry 2.0 Guide de l'utilisateur Page 50