Sentry Sentry 2.0 Guía de usuario descargar pdf (Pagina 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

Sin comentarios

Sentry Sentry 2.0 Guía de usuario Pagina 50