--自己试试应该可以防问的。SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVERLOCAL','','SQLOLEDB','192.168.1.123'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVERLOCAL','FALSE',NULL,'SA','9588'
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVER123','','SQLOLEDB','192.168.12.3'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVER123','FALSE',NULL,'SA',''
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVER250','','SQLOLEDB','192.168.1.250'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVER250','FALSE',NULL,'SA','9588'
---------------------------------------------------------------------------
GO/*
----------------------------------------------------------
--将新系统编码转换成新编码
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[DEF_MTID_D] SET
DEF_MTTYPE_ID=dbo.z_GetMTTYPE(DEF_MTID_M_ID)
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[TH_D] SET
DEF_MTTYPE_ID= dbo.z_GetMTTYPE(DEF_MTID_M_ID)
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[TH_COST] SET
DEF_MTTYPE_ID= dbo.z_GetMTTYPE(DEF_MTID_M_ID)
-----------------------------------------------------------
--将旧系统仓库数据转换成新编码
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[MT_IOC] SET
MT_IOC_YLTYPE= dbo.z_GetMTTYPE(MT_IOC_MTID)
*/
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVERLOCAL','SA'
GO
EXEC SP_DROPSERVER 'SERVERLOCAL','DROPLOGINS'
GO
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVER250','SA'
GO
EXEC SP_DROPSERVER 'SERVER250','DROPLOGINS'
GO
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVER123','SA'
GO
EXEC SP_DROPSERVER 'SERVER123','DROPLOGINS'
GO
GO
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVERLOCAL','','SQLOLEDB','192.168.1.123'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVERLOCAL','FALSE',NULL,'SA','9588'
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVER123','','SQLOLEDB','192.168.12.3'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVER123','FALSE',NULL,'SA',''
---------------------------------------------------------------------------
EXEC SP_ADDLINKEDSERVER 'SERVER250','','SQLOLEDB','192.168.1.250'
EXEC SP_ADDLINKEDSRVLOGIN 'SERVER250','FALSE',NULL,'SA','9588'
---------------------------------------------------------------------------
GO/*
----------------------------------------------------------
--将新系统编码转换成新编码
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[DEF_MTID_D] SET
DEF_MTTYPE_ID=dbo.z_GetMTTYPE(DEF_MTID_M_ID)
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[TH_D] SET
DEF_MTTYPE_ID= dbo.z_GetMTTYPE(DEF_MTID_M_ID)
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[TH_COST] SET
DEF_MTTYPE_ID= dbo.z_GetMTTYPE(DEF_MTID_M_ID)
-----------------------------------------------------------
--将旧系统仓库数据转换成新编码
UPDATE SERVERLOCAL.[GSJBBH].[dbo].[MT_IOC] SET
MT_IOC_YLTYPE= dbo.z_GetMTTYPE(MT_IOC_MTID)
*/
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVERLOCAL','SA'
GO
EXEC SP_DROPSERVER 'SERVERLOCAL','DROPLOGINS'
GO
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVER250','SA'
GO
EXEC SP_DROPSERVER 'SERVER250','DROPLOGINS'
GO
GO
EXEC SP_DROPLINKEDSRVLOGIN 'SERVER123','SA'
GO
EXEC SP_DROPSERVER 'SERVER123','DROPLOGINS'
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货