After you've tested it, put the schema and procedures into the model database, if (and only if) you expect all your databases look the same. Either that, or your suggestion of building a shell database, you could script it, and run the script to create other databases.

________________________________

From: Arnie [mailto:mssqldba-ezmlmshield-x607152.[Email address protected]
Sent: Tue 8/29/2006 11:05 AM
To: LazyDBA Discussion
Subject: stored procedures





Gentlemen & Ladies



I have an accounting system with several companies.

Each company has it's own database.



Up to this point, I have stored procedures scattered willy-nilly
everywhere. I want to organize them.

Specifically, I want them organized so the can be equally accessible
across all companies.





I think I will set up a shell company whose purpose is to house
stored procedures and user defined functions



How would 'best practices' suggest I handle this?

Or, how would the best of you guys handle this?



Thanks Much

Arnie







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






-----------------------------------------
IMPORTANT NOTICE: This message is intended only for the addressee
and may contain confidential, privileged information. If you are
not the intended recipient, you may not use, copy or disclose any
information contained in the message. If you have received this
message in error, please notify the sender by reply e-mail and
delete the message.


MS Sql Server LazyDBA home page