Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malachi151
Posting Yak Master
152 Posts |
 Posted - 2009-09-09 : 11:54:31
|
| Where I work we have hundreds of databases, many of them very similar. We do a lot of data importing and cleansing, etc.There are lots of very useful user defined functions that we could be using, but aren't yet, but I'm wonderig what is the best way to implement these?Should I create them in the mater database? The only options I cna think of are:1) Create all the common function in the mater db2) Put them all in some other DB and reference them from there whe they are used in other dbs.3) Create them in every db.Am I missing something, and if not, which of these is the best option?Thanks |
|
|
malachi151
Posting Yak Master
152 Posts |
Posted - 2009-10-02 : 10:50:04
|
| Anyone? Is it appropriate practise to put you UDFs in the master DB? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 11:33:10
|
| we create udfs in db where we use it itself. we dont have same objects existing across dbs so wont require udfs to be shared across dbs |
|
|
|
|
|
|
How to manage user functions?