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 |
|
CartesianJoin
Starting Member
11 Posts |
 Posted - 2005-01-25 : 12:22:46
|
| I created a few UDF's in a db as user sysdba. They show up in the db listing under UDFs and as owned by sysdba.If I call them, they cannot be found even if I prepend them with sysdba (ie sysdba.Function_Name(param1, param2))I was logged in as sysdba at the time. I logged in as sa and, after properly naming all the objects, the UDF works fine.I cannot, for the life of me, call the function as the user that created it. It deosn't say anything about a security violation, it says it can't find it.The present name of the function is : sysdba.CurrConvert_Product_Cost()it is called thus:sysdba.CurrConvert_Product_Cost(Product_CostID, 'CAD')error returned is:Server: Msg 195, Level 15, State 10, Line 2'CurrConvert_Product_Cost' is not a recognized function name.works fine when logged in as sa and invoked thus:Select sysdba.CurrConvert_Product_Cost(Product_CostID, 'CAD')From sysdba.Product_CostSQL Server 2000 on Win Server 2000.Any suggestions? Is there a name length limit I am hitting or something? |
|
|
CartesianJoin
Starting Member
11 Posts |
Posted - 2005-01-25 : 12:34:31
|
| Ignore, I am an idiot. There was an invocation of the function off my screen that I missed and hadn't added the owner to. My bad and I am properly embarrased. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-25 : 12:38:09
|
change the user in front of the computer.  Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
|
|
Calling my UDF