Any potential issues with putting a Stored Procedure in Master?

• jasona.work

  SSC Guru

  Points: 50137

  More actions

  March 27, 2013 at 8:12 am

  #272614

  I'm working in a rather locked down environment, and would rather avoid adding a DB if I can. I'm thinking of using the CheckDB procedure created by Gianluca Sartori[/url] to run a weekly DBCC CheckDB against all DBs on the servers.

  Other than the normal "don't use the system DBs for user stuff" is there any potential issues?

  Although I am going to check, and see if I can create a DB for these sort of tools, and if so, use that instead.

  Thanks,

  Jason

• Erin Ramsay

  SSCrazy Eights

  Points: 9728

  More actions

  March 27, 2013 at 8:15 am

  #1601170

  Good idea in my mind, Jason. I generally have a utility database from which those types of things run.

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 27, 2013 at 8:23 am

  #1601172

  You can do it. I prefer to avoid master for the reason of having one more database to check for objects when migrating to a different server (for example). But in a pinch, master works.

  Another I have sometimes used, when in a pinch, is msdb.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• jasona.work

  SSC Guru

  Points: 50137

  More actions

  March 27, 2013 at 8:37 am

  #1601185

  Cool, thanks to both of you!

  Jason

• ScottPletcher

  SSC Guru

  Points: 101166

  More actions

  March 27, 2013 at 8:52 am

  #1601195

  You could easily use master for that. Especially given that you must use master for some procedures anyway. Moreover, it's much easier from SQL2005 on to distinguish your objects from the base system objects, because system objects are owned by 'sys', while yours are owned by 'dbo'.

  SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".