[quoted text, click to view]

In fact, I want to query the 2000 server from 2005 so I can use the

I tried

SELECT *
FROM OPENROWSET('SQLOLEDB',
'Trusted_Connection=yes;Integrated Security=SSPI;Data
Source=DBS-004;Initial Catalog=Db1',
'select * from db1.dbo.Parts'
) as result

However, always got error:

OLE DB provider "SQLNCLI" for linked server "(null)" returned message
"Deferred prepare could not be completed.".
Msg 8180, Level 16, State 1, Line 1
Statement(s) could not be prepared.
Msg 208, Level 16, State 1, Line 1