--试试用:
if exists(select 1 from master..sysservers where srvname='huab')
exec sp_dropserver 'huab','droplogins'exec sp_addlinkedserver 'huab','','SQLOLEDB','webser'
exec sp_addlinkedsrvlogin 'huab','false',null,'sa'GO
select * from huab.erp_data.dbo.ba01
if exists(select 1 from master..sysservers where srvname='huab')
exec sp_dropserver 'huab','droplogins'exec sp_addlinkedserver 'huab','','SQLOLEDB','webser'
exec sp_addlinkedsrvlogin 'huab','false',null,'sa'GO
select * from huab.erp_data.dbo.ba01
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)Server: Msg 17, Level 16, State 1, Line 1
SQL Server 不存在或拒絕存取。