SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Invalid object name <TableName>
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sonu
Posting Yak Master

110 Posts

Posted - 12/21/2004 :  11:48:35  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 12/21/2004 :  12:28:10  Show Profile  Visit chadmat's Homepage  Reply with Quote
Are you calling dbo.udfName or just UDFName? Try adding dbo. to the beginning if you don't have it there.


-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1600 Posts

Posted - 12/21/2004 :  12:34:32  Show Profile  Reply with Quote
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)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000