Sentry Sentry 2.0 Guia do Utilizador Página 43

  • Descarregar
  • Adicionar aos meus manuais
  • Imprimir
  • Página
    / 56
  • Índice
  • MARCADORES
  • Avaliado. / 5. Com base em avaliações de clientes
Vista de página 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 página 42
1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 55 56

Comentários a estes Manuais

Sem comentários