Sentry Sentry 2.0 Podręcznik Użytkownika Pobierz pdf (Strona 43)

dropprocedure[dbo].[spTrapAlert_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[spSetupAlertsTrap_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[spSetupAlertsTrap_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[SQLSentryAlertLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptable[dbo].[SQLSentryAlertLog_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[SQLSentryLogData_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptable[dbo].[SQLSentryLogData_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[SQLSentryObjectVersion_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptable[dbo].[SQLSentryObjectVersion_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[fnGetSQL_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)

dropfunction[dbo].[fnGetSQL_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[fnGetWaittypeDesc_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)

dropfunction[dbo].[fnGetWaittypeDesc_20]

USEmsdb

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[sp_sentry_mail]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[sp_sentry_mail]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[sp_sentry_mail_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[sp_sentry_mail_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[SQLSentryEmails_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptable[dbo].[SQLSentryEmails_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[spGetBlockInfo_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[spGetBlockInfo_20]

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].

[spGetBlockInfo_Pre8sp3]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[spGetBlockInfo_Pre8sp3]

BEGINTRANSACTION

DECLARE@JobIDBINARY(16)

DECLARE@ReturnCodeINT

SQL Sentry Quick Start 43

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 55 56

Brak uwag

Sentry Sentry 2.0 Podręcznik Użytkownika Strona 43