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 |
sonu
Posting Yak Master
110 Posts |
Posted - 2004-12-21 : 11:48:35
|
Hello, I have a sp which calls a UDF function. That works locally very well. But when I deploy it to the server, then I get the errror:Invalid object name <TableName>I have already set the ownership of the UDF to dbo. Now when I remove this function from my sp, then the sp works fine. This is reason that I am sure the the UDF is causing this error. Does anybody know what I have to do else to get this working?Thanks |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-12-21 : 12:28:10
|
Are you calling dbo.udfName or just UDFName? Try adding dbo. to the beginning if you don't have it there.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-21 : 12:34:32
|
Can we see the script that actually generates this error? Otherwise we're just shotting blind.HTH=================================================================The best things in life are nearest: Breath in your nostrils, light in your eyes, flowers at your feet, duties at your hand, the path of right just before you. -Robert Louis Stevenson, novelist, essayist, and poet(1850-1894) |
|
|
|
|
|