Functions in Master

[gavinjb]

Hi,

I am fairly new to SQL Server and am trying to find out if there is a way to create a function in master db (I want all databases to be able to access the function) that can then be called by any db on server without having to reference the db name

e.g. master.db.functionname(parameters)


Thanks,


Gavin,

 

[SQL_Hell]

No I dont think you can do that,

you will have to use <dbanme>.dbo.<fuctionname>

Personally I would refrain from storing things in the master database anyway