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的客户端