USE [master]GO/****** Object:  LinkedServer [MobileMDMlinkServer ]    Script Date: 2014/7/23 11:10:16 ******/EXEC master.dbo.sp_addlinkedserver @server = N‘MobileMDMlinkServer ‘,    @srvproduct = N‘ ‘, @provider = N‘SQLNCLI‘, @datasrc = N‘对应数据库实例‘ /* For security reasons the linked server remote logins password is changed with ######## */EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N‘MobileMDMlinkServer ‘,    @useself = N‘False‘, @locallogin = NULL, @rmtuser = N‘sa‘,    @rmtpassword = ‘########‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘collation compatible‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘data access‘, @optvalue = N‘true‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘dist‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘pub‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘rpc‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘rpc out‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘sub‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘connect timeout‘, @optvalue = N‘0‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘collation name‘, @optvalue = NULLGOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘lazy schema validation‘, @optvalue = N‘false‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘query timeout‘, @optvalue = N‘0‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘use remote collation‘, @optvalue = N‘true‘GOEXEC master.dbo.sp_serveroption @server = N‘MobileMDMlinkServer ‘,    @optname = N‘remote proc transaction promotion‘, @optvalue = N‘true‘GO