alter database iERP81_NexenLA set SINGLE_USER WITH ROLLBACK IMMEDIATE

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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