SQL Server Performance Forum – Threads Archive

Linked Servers Issue

I just got into SQL Server 2005 and loading data from SQL Server 2000 databases. I have many data sources running on SQL Server 2000 and need to be created linked server between SQL Server 2005 and 2000 servers. Everything is fine so far but when I execute the distributed queries on SQL Server 2005 then I am getting the error message and the solution is given in Microsoft site by running one of the script (the solution is provided in the given microsoft website link). The Error Message:
The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "<LinkedServerName>". The provider supports the interface, but returns a failure code when it is used. Solution in Microsoft:
http://support.microsoft.com/default.aspx?scid=kb;en-us;906954 But I don’t have control on all SQL server 2000 source boxes so how would I accomplish my task loading data from SQL server 2000 to 2005 every day without linked servers. Moreover the microsoft solution is only for SQL Server 2000 and its not for SQL Server 7. I have one data source server has SQL server 7.0. Any help or suggestions on this issue is greatly appreciated. Bhushan

---

Hi, May be this link will help. http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=74&threadid=48124&enterthread=y Waqar. ________________________________________________
~* Opinions are like a$$holes, everyone got one. *~

---

]]>