I made a linked server between two sql server instances. The remote one I have very little control over. When I try a query I get this:
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "172.18.4.179\JOURNYX". The provider supports the interface, but returns a failure code when it is used.
Is there any good way around this without having to do admin-level actions on the remote system?