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 |
|
DrewBurlingame
Starting Member
49 Posts |
 Posted - 2002-05-06 : 16:00:19
|
| We changed some tables referenced by some UDF's. Now when we run those UDF's, we get the following error message:OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile timeThe UDF's access the tables through a linked server connection.So I went to recompile, but can't find a way to recompile UDF's.Additionally, I tried the UDF select statement from another server and got the same error, so I am wondering if it's not necessarily the UDF now. I'm not familiar with the caching and how to reset it. I stopped and restarted the sql service on the linked server, and the udf server, but I'm getting the same results.Any ideas?Thanks for you help,Drew |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-05-06 : 16:12:36
|
| I believe dropping and then recreating the linked server might sort this. This is actually a fairly common error for linked servers and a pain in the butt ! Here's one explanation[url]http://groups.google.com/groups?hl=en&selm=91t9ad%249sd%241%40nnrp1.deja.com[/url]HTHJasper Smith |
 |
|
|
DrewBurlingame
Starting Member
49 Posts |
Posted - 2002-05-06 : 22:52:28
|
| Dropping the server and readding it didn't do the trick. But the link was the perfect help. I backed-up and dropped the tables and their constraints, readded the table, adn then restored their data and constraints. All is working again.Thanks for your help Jasper. YOU are my hero!!!Drew |
|
|
|
|
|
|
Recompiling a Function