Sentry Sentry 2.0 Podręcznik Użytkownika Pobierz pdf (Strona 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

Brak uwag

Sentry Sentry 2.0 Podręcznik Użytkownika Strona 50