Home Forums SQL Server 2008 SQL Server 2008 - General Stored Procedure is not responding, i am executing but does nothign and donot execute RE: Stored Procedure is not responding, i am executing but does nothign and donot execute

  • July 4, 2013 at 10:42 pm

    #1629925

    The DROP procedure statement refers to a different procedure:

    DROP PROCEDURE [dbo].[NIC_OA_GetPatientXRayReportsOut]

    create PROCEDURE [dbo].[NIC_OA_GetPhysicianXRayReportsOut]

    One is PatientXray, the other is PhysicianXray, change DROP statement to:

    IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[NIC_OA_GetPhysicianXRayReportsOut]') AND type in (N'P', N'PC'))

    DROP PROCEDURE [dbo].[NIC_OA_GetPhysicianXRayReportsOut]

    GO