急急急!高分请教!
zzj 2000-08-07 09:29:00 SQL Server 7.0,Windows2000 Server.局域网中两个Sql Server服务器,进行互相访问,以前一切正常,现在突然出错.现象:
--登记服务器
exec sp_addlinkedserver 'ap-ctu',N'SQL Server'
--连接服务器
exec sp_addlinkedsrvlogin 'ap-ctu',false,'sa','sa','nightmare'
--访问表,--上面都成功
select t1.FNumber FROM [ap-ctu].AIS20000531181622.dbo.t_Account t1
--删除服务器
exec sp_dropserver 'ap-ctu','droplogins'
执行访问表时出错:Server: Msg 7353, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
而在ap_ctu的Sql Query Analyzer中执行上面访问表语句select t1.FNumber FROM [ap-ctu].AIS20000531181622.dbo.t_Account t1又正常.通过DBCC CHECKTABLE ('t_Account')后再互相访问仍正常,请问为什么?