SQL 跨服务器访问

 exec sp_addlinkedserver 'linkserver','','SQLOLEDB','远程服务器地址'

 exec sp_addlinkedsrvlogin 'linkserver','false',null,'用户名','密码'

IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srvid != 0 AND srvname = N'linkserver') EXEC master.dbo.sp_dropserver @server=N'linkserver', @droplogins='droplogins'

 

 

提醒:如果希望SQL2005跨服务器访问SQL2008,则有以下两种方式提供参考:

1 SQL2005上打SP3的补丁.

2 SQL2005上安装SQL2008的客户端