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?