DEVELOPMENT: Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI” for linked server

May 08, 2009

Running a query from SQL Server 2008 over a linked server connection to a SQL Server 2000 server causes the following error: OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “Unspecified error”. OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “The stored procedure required to complete this operation could notbe found […]