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

Thanks Gustav.



John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> 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?
>