ServiceManager.Report.Compliance.ControlManagement.SP.GetComplianceIncidentsList.Uninstall (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManager.Report.Compliance.ControlManagement.SP.GetComplianceIncidentsList.Uninstall" Accessibility="Public" FileName="ServiceManager.Report.GRC.IncidentManagement.SP.ListOfIncidents.Uninstall.sql"/>

File Content: ServiceManager.Report.GRC.IncidentManagement.SP.ListOfIncidents.Uninstall.sql

SET ANSI_NULLS ON


GO


SET QUOTED_IDENTIFIER ON


GO





-- Drop stored procedure if it already exists


IF EXISTS (


  SELECT * 


    FROM INFORMATION_SCHEMA.ROUTINES 


   WHERE SPECIFIC_SCHEMA = N'dbo'


     AND SPECIFIC_NAME = N'ServiceManager_Report_GRC_IncidentManagement_SP_ListOfIncidents'


)


   DROP PROCEDURE dbo.ServiceManager_Report_GRC_IncidentManagement_SP_ListOfIncidents


GO