I am facing a problem with linked servers.
I have two servers running sql server I have created a linked server
definition on one of them and have mapped a login for the remote server.
This remote login has select permissions on a few tables. When I try to run
a 'select ' on a particular table on the linked server it gives me the
'Server: Msg 7353, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column
was supplied during execution that was not found at compile time.'
Selects on all other tables with similar permissions work.
I have tried to delete the linked server definition and recreate it but
nothing seems to work.
Can somebody please tell me what the possible reason could be and how I
could remedy it?
Thanks in advance