2012 to 2000 using ODBC

電腦小知識

USE master

GO

— Drop Existing LinkedServer [NorthWind2000]:

EXEC sp_dropserver @server=N’NorthWind2000′, @droplogins=’droplogins’

GO

— Re-create LinkedServer [NorthWind2000] by using the ODBC connection:

EXEC sp_addlinkedserver @server = N’NorthWind2000′,

@srvproduct=N",

@provider=N’MSDASQL’,

@provstr=N’DRIVER={SQL Server};SERVER=NorthWind;Trusted_Connection=yes;’

EXEC sp_addlinkedsrvlogin @rmtsrvname=N’NorthWind2000′,

@useself=N’True’,

@locallogin=NULL,

@rmtuser=NULL,

@rmtpassword=NULL

GO

, , ,