Sentry Sentry 2.0 Guía de usuario Pagina 43

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 56
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 42
dropprocedure[dbo].[spTrapAlert_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[spSetupAlertsTrap_20]')andOBJECTPROPERTY(id,N'IsProcedure')=1)
dropprocedure[dbo].[spSetupAlertsTrap_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryAlertLog_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryAlertLog_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryLogData_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryLogData_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[SQLSentryObjectVersion_20]')andOBJECTPROPERTY(id,N'IsUserTable')=1)
droptable[dbo].[SQLSentryObjectVersion_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetSQL_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[dbo].[fnGetSQL_20]
ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].
[fnGetWaittypeDesc_20]')andOBJECTPROPERTY(id,N'IsScalarFunction')=1)
dropfunction[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]
GO
BEGINTRANSACTION
DECLARE@JobIDBINARY(16)
DECLARE@ReturnCodeINT
SQL Sentry Quick Start 43
©2015 SQL Sentry. All Rights Reserved.
Vista de pagina 42
1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 55 56

Comentarios a estos manuales

Sin comentarios