Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BDipalmo
Starting Member
2 Posts |
 Posted - 2004-07-12 : 08:21:09
|
| A colomn was added to a table on server A.Now, when attempting to access the table from Server B via a linked server I recieve the message:Server: Msg 7353, Level 16, State 1, Line 1OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.It looks as though i need to refresh the metadata of the linked server to incorporate the change to the table. I have deleted and reset the linked server, but this failed to correct the problem. Any ideas? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-12 : 08:27:26
|
| Where are you executing this query from? Are you accessing the table in Enterprise Manager or something?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
BDipalmo
Starting Member
2 Posts |
Posted - 2004-07-12 : 09:05:20
|
| Both Enterprise Manager and Query Analyzer return the same error message. |
|
|
|
|
|
|
Linked Server - Inconsistent Metadata