DROP a Stored Procedure in SQL Server

-- ============================

-- DROP YOUR EXISTING PROCEDURE

-- ============================

IF EXISTS (SELECT * FROM DBO.SYSOBJECTs where id = OBJECT_ID(N'[dbo].[sp_Get_XX]')

AND OBJECTPROPERTY(id, N'IsProcedure') = 1)

    DROP PROCEDURE [dbo].[sp_Get_XX]

GO

                                       --OR

IF OBJECT_ID('[dbo].[sp_Get_XX]') IS NOT NULL

    DROP PROCEDURE [dbo].[sp_Get_XX]

GO

                                      --OR

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = '[dbo].[sp_Get_XX]' AND TYPE = 'P')

            DROP PROCEDURE [dbo].[sp_Get_XX]

GO

                                    -- OR

DROP PROC [dbo].[sp_Get_XX]