SQLServer cannot find my user defined function function in stored procedure?

Works for me Try CREATE FUNCTION dbo. UfTest I assume your default schema can't be dbo and it's ending up in a different schema. Otherwise the only explanation I can think of is you might need to grant permissions on it.

Works for me. Try CREATE FUNCTION dbo. UfTest ... I assume your default schema can't be dbo and it's ending up in a different schema.

Otherwise the only explanation I can think of is you might need to grant permissions on it.

1 +1: Works on 2005 for me too. If the procedure is created in a different database, the function will need three name notation to be referenced properly. – OMG Ponies Jan 15 at 0:24 No dice.

If you notice the end of my original post. It is showing up under the proper database in Management Studio. – Josh Russo Jan 15 at 0:55 1 Can you right click the scalar function in SSMS under the account you use to create these objects, choose "script function as select to..." Fill in the parameter value and execute it standalone?

If yes can you execute it from the stored procedure in SSMS under that same account? If Yes and the problem is in your application you will need to do GRANT EXECUTE ON dbo. UfTest TO username also you aren't just going off what intellisense claims?

– Martin Smith Jan 15 at 3:57 @Martin Thank You! It worked all along. It was SSMS screwing me up.It underlined the call to the function saying that it couldn't find it, so I never bothered actually trying to run it.

– Josh Russo Jan 15 at 20:48 1 @Martin I just realized that this was your answer. LOL I was a little frazzled from this problem that didn't make any sense. Thanks again for walking me through it.

– Josh Russo Jan 157 at 14:46.

Script out the UDF and check the schema name. It's probably not dbo. I would change the UDF definition to specifically include dbo.In other words: CREATE FUNCTION dbo.ufTest.

It was created as dbo. UfTest, but I did try adding it and still no dice. – Josh Russo Jan 15 at 0:53.

Try calling it with a select instead of a set. And you checked that out belongs to the dbo schema?

Tried the select trick too, but that's really only appropriate if you're returning a Table – Josh Russo Jan 15 at 0:56 Or when assigning multiple values at once or when you using a where clause or when inside a function called ufTest ;) But that aside it does handle null values differently which your case is using so was worth a shot. You got a crazy non replicable issue there, best of luck! – Adam Jan 15 at 1:38 What exactly do you mean by assigning multiple values?

Multiple out arguments? Actually it turned out that it was just SSMS giving a false error in the query editor, so I never actually tried to run it. – Josh Russo Jan 16 at 14:43 Just talking about comma separated assignments; you can't do it with set nothing big.

I am glad you got your issue figured out. – Adam Jan 16 at 17:44.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.