>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?