alter database iERP81_NexenLA set SINGLE_USER WITH ROLLBACK IMMEDIATE

alter database iERP81_NexenLA set SINGLE_USER WITH ROLLBACK IMMEDIATE
alter database iERP81_NexenLA set MULTI_USER

alter database iERP81_NexenLA set NEW_BROKER

USE iERP81_NexenLA;
GO

ALTER PROCEDURE [dbo].[usp_ESync_SendMessage] @msg XML, @MessageType varchar(128)
AS 
    BEGIN
        SET NOCOUNT ON ;
		
    END
GO

ALTER PROCEDURE [dbo].[usp_OSync_SendMessage] @msg XML, @MessageType varchar(128)
AS 
    BEGIN
        SET NOCOUNT ON ;
    END
GO

DROP ROUTE Route_OSync_Office_Track
DROP ROUTE Route_OSync_Office
DROP ROUTE Route_ESync_Office
DROP ROUTE Route_ESync_Office_Back
DROP ROUTE Route_Test_SourceOffice
DROP ROUTE Route_Test_TargetERP