-- 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