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

Hi John

Model?

Or run your own: cccommon or ccsys - you get the idea.

/gustav

>>> jwcolby at colbyconsulting.com 04-06-2008 18:05 >>>
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