We talk about Function or SP?
What type of function? Can you post its code?
>The UDF needs to get it's data from the current database and calling the UDF with Master in front will cause the UDF to try and get the data from Master.
>
>-Dan
>
>>SELECT Master.dbo.MyFunc()
>>
>>>Borislav,
>>>
>>>Thanks for the response. I added it to the master DB and I am still getting the Invalid object name when trying to use it.
>>>
>>>-Dan
>>>
>>>>>I would like to create a public UDF and use it in a SELECT statement. The UDF works correctly when it's located in the same database but I don't want to have to update multiple databases if the UDF ever changes. I have created a UDF and issued -
>>>>>
>>>>>
>>>>>GRANT Execute ON myudf to public
>>>>>
>>>>>
>>>>>How can I then use this UDF in a SELECT in a different database without referencing the database that the UDF is in? I get the error "Invalid object name 'dbo.myudf' when executing -
>>>>>
>>>>>
>>>>>SELECT dbo.myudf()
>>>>>
>>>>>
>>>>>TIA
>>>>>
>>>>>-Dan
>>>>
>>>>Why not create it in Master DB?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.