After adding two columns to a SQL Server 7 (SP3) table we have found that a view from a linked server has stopped working with the message:
SQL OLEDB supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
This is not the first time we have added columns to this particular table but its the first time we've had problems. We used named fields in the view, but even trying 'select *' yields the same error message.
We have stopped + started both servers, dropped + recreated the server link and dropped + recreated the view but nothing works.
If we take the extra columns out again, everything works.
Anyone any ideas?
SQL OLEDB supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.
This is not the first time we have added columns to this particular table but its the first time we've had problems. We used named fields in the view, but even trying 'select *' yields the same error message.
We have stopped + started both servers, dropped + recreated the server link and dropped + recreated the view but nothing works.
If we take the extra columns out again, everything works.
Anyone any ideas?