Sentry Sentry 2.0 Betriebsanweisung PDF herunterladen (Seite 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

Keine Kommentare

Sentry Sentry 2.0 Betriebsanweisung Seite 50