[dba-SQLServer] Where do you put generic stored procedures

jwcolby jwcolby at colbyconsulting.com
Wed Jun 4 11:05:43 CDT 2008


I have a half dozen databases, which I am creating standard 
field names for, and then creating parameterized stored 
procedures to allow me to do things like drop specific 
indexes, rebuild those indexes, update a set of hash fields etc.

Where would I put these stored procedures.  I understand 
some people do not think putting them in the Master database 
is a good idea, but they do not "belong" to any of the 
specific databases either.

Do you create your own database and place them in there? 
Some other strategy?

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list