Hi All,
One of my clients has installed SQL5K at their HeadOffice. However there are some production units are there running under SQL2K. We have one stored procedure which used to update the masters from HO to Units. Under SQL2K it was working fine, but when we run the procedure on HO under SQL5K, it returns the following error message.
**************************************
OLE DB provider "SQLNCLI" for linked server "charlie1" returned message "Unspecified error".
OLE DB provider "SQLNCLI" for linked server "charlie1" returned 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 4
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "charlie1". The provider supports the interface, but returns a failure code when it is used.
*************************************
The above also ocurs when I simply issue the command :
SELECT * FROM [server2K].[Mydatabase].[dbo].[MyTable]
I've tried to add the server with "sp_addlinkedserver" it was added successfully. The login info is same across the servers.
Please help me out I am stuck badly.
Thanks
Raoshan