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 |
|
dnf999
Constraint Violating Yak Guru
253 Posts |
 Posted - 2007-02-23 : 10:10:40
|
| HiI am creating SP's for my Team to use when we run analysis jobs. I.e. Table audit scripts, check scripts...etc.As they are quite novice users, is it permissable to load SP's onto the masterDB of SQL Server therefore, when a user creates their own db, they can execute SP's from MasterDB from their DB's and the resulting tables be prodcued in their db's?This would mean that SP's would not have to be loaded on every new DB created and I could facilitate any changes on a master level.Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-23 : 21:16:39
|
| >> As they are quite novice users!!!Why not try it and see - would probably take less time than to post the question.I usually put such things in an admin database.You could also add the SPs to the model database and they would be added to any new database created.But what's the problem with just adding them to a new database? You could even run a nightly task that adds these SPs to all databases in case some change - not saying it would be a good idea but don't think there is a technical issue here.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Load & Execute SP's from Master db?