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.