title: Using linked server returns error - "Cannot obtain the schema rowset for OLE DB provider"
body: <p>I tried to move data aka ETL from one sql server to another as mentioned in a previous question - <a href="https://stackoverflow.com/questions/19459959/copy-data-from-one-column-into-another-column">Copy data from one column into another column</a>. Now, I get an error when I try to execute a query.</p>
  
  <p>Query - </p>
  
  <pre><code>INSERT INTO [Target_server].[Target_DB1].[dbo].[Target_Table1](Target_Column1)
  SELECT Source_Column222
  FROM [Source_server].[Source_DB1].[dbo].[Source_Table1]
  WHERE Source_Column1 = 'ID7162'
  </code></pre>
  
  <p>Error - </p>
  
  <pre><code>OLE DB provider "SQLNCLI" for linked server "MYLINKEDSERVER" returned message "Unspecified error".
  OLE DB provider "SQLNCLI" for linked server "MYLINKEDSERVER" 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 1
  Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "MYLINKEDSERVER". The provider supports the interface, but returns a failure code when it is used.
  </code></pre>