-- 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_ConfigurationManager_SP_GetPowerActivityData'
)
DROP PROCEDURE ServiceManager_Report_ConfigurationManager_SP_GetPowerActivityData
GO