Savision_Community_SLAReport_ManagementPack_Uninstall.sql (Resource)

Element properties:

Source Code:

<Resource ID="Savision_Community_SLAReport_ManagementPack_Uninstall.sql" Accessibility="Internal" FileName="Savision_Community_SLAReport_ManagementPack_Uninstall.sql" HasNullStream="false"/>

File Content: Savision_Community_SLAReport_ManagementPack_Uninstall.sql

IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelAgreementMetadataGet')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelAgreementMetadataGet')


END





IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelAgreementObjectiveAvailabilityMonitorDataGet')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelAgreementObjectiveAvailabilityMonitorDataGet')


END





IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelAgreementObjectiveDataGet')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelAgreementObjectiveDataGet')


END





IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelObjectiveGetByServiceLevelAgreement')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelObjectiveGetByServiceLevelAgreement')


END


GO





IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelObjectiveManagedEntityDetailDataGet')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelObjectiveManagedEntityDetailDataGet')


END


GO


IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ManagedEntityMonitorDependencyList')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ManagedEntityMonitorDependencyList')


END


GO


IF EXISTS (SELECT * FROM sys.objects WHERE [schema_id]=SCHEMA_ID('dbo') AND type = 'P' AND name = 'Savision_Community_SLA_ServiceLevelAgreementManagedEntityGet')


BEGIN


	EXECUTE ('DROP PROCEDURE dbo.Savision_Community_SLA_ServiceLevelAgreementManagedEntityGet')


END


GO