Sentry Sentry 2.0 Guia do Utilizador descarregar pdf (Página 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

Sem comentários

Sentry Sentry 2.0 Guia do Utilizador Página 50