ServiceManager.Report.ProblemManagement.SP.GetListOfProblems.Uninstall (Resource)

Element properties:

Source Code:

<Resource ID="ServiceManager.Report.ProblemManagement.SP.GetListOfProblems.Uninstall" Accessibility="Public" FileName="ServiceManager.Report.ProblemManagement.SP.GetListOfProblems.Uninstall.sql"/>

File Content: ServiceManager.Report.ProblemManagement.SP.GetListOfProblems.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_ProblemManagement_SP_GetListOfProblems' 


)


   DROP PROCEDURE dbo.ServiceManager_Report_ProblemManagement_SP_GetListOfProblems


GO