/* LAYER1_INBOUND_PILOT_V1 rollback removes only the owned procedure. */
SET NOCOUNT ON;
SET XACT_ABORT ON;

IF DB_NAME() <> N'FT546-wms'
    THROW 51119, 'Run this script only in FT546-wms', 1;

IF OBJECT_ID(N'dbo.proc_allot_layer1_inbound_pilot', N'P') IS NOT NULL
BEGIN
    IF CHARINDEX(N'LAYER1_INBOUND_PILOT_V1',
            OBJECT_DEFINITION(OBJECT_ID(N'dbo.proc_allot_layer1_inbound_pilot'))) = 0
        THROW 51120, 'Refusing to drop an unowned procedure', 1;
    DROP PROCEDURE dbo.proc_allot_layer1_inbound_pilot;
END;

SELECT 'LAYER1_INBOUND_PILOT_ROLLBACK_OK' AS result;