Executing SP''s from MasterDB.....?

• dnf999

  SSC Eights!

  Points: 870

  More actions

  February 23, 2007 at 9:38 am

  #172150

  Hi

  I 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

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  February 23, 2007 at 10:00 am

  #691476

  You can put those sps in model.  So when the new dbs are created they will include those sps.

   

  Giving them access to master might not be the best idea if they are true novices.