Sentry Sentry 2.0 Guía de usuario descargar pdf (Pagina 47)

10.3.2

Object Removal Script for Watched 2005 and

Above Servers

Object Removal Script for Watched 2005 and above

USEmsdb

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

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

dropprocedure[dbo].[sp_sentry_mail]

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

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

dropprocedure[dbo].[sp_sentry_mail_20]

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

[sp_sentry_dbmail_20]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[sp_sentry_dbmail_20]

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

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

droptable[dbo].[SQLSentryEmails_20]

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

[SQLSentryDBEmails_Attachments_20]')andOBJECTPROPERTY(object_id,

N'IsUserTable')=1)

droptable[dbo].[SQLSentryDBEmails_Attachments_20]

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

[SQLSentryDBEmails_20]')andOBJECTPROPERTY(object_id,N'IsUserTable')=

droptable[dbo].[SQLSentryDBEmails_20]

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

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

dropprocedure[dbo].[spGetBlockInfo_20]

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

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

dropprocedure[dbo].[spGetBlockInfo_Pre8sp3]

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

[spGetQueryStatsData]')andOBJECTPROPERTY(object_id,N'IsProcedure')=1)

dropprocedure[dbo].[spGetQueryStatsData]

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

[spGetProcedureStatsData]')andOBJECTPROPERTY(object_id,N'IsProcedure')

=1)

dropprocedure[dbo].[spGetProcedureStatsData]

BEGINTRANSACTION

DECLARE@JobIDBINARY(16)

SQL Sentry Quick Start 47

1 2 ... 42 43 44 45 46 47 48 49 50 51 52 ... 55 56

Sin comentarios

Sentry Sentry 2.0 Guía de usuario Pagina 47