Hi all,
We have a server (call it server D) with linked server connections to 3 of
our others servers (call them a,b,c).
We get the error message below whenever we run an sp or query on server d
that looks at a table on a,b or c that we have added or deleted columns in.
This has happened several times and the solution to this point has been to
delete all three of the linked server connections and then recreate them so
they recognize the updated version of the altered table(s). Is there anyway
to have the updates recognized automatically?


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.

Thanks,
Elecia

MS Sql Server LazyDBA home page