|
|
Posted by Hugo Kornelis on 11/25/06 22:55
On Fri, 24 Nov 2006 10:57:21 -0800, George Shubin wrote:
>Thanks, Hugo.
>
>Putting the tables in there just might be the ticket. I didn't know that
>was one of the purposes of the Model database.
>
>Thanks for the suggestions.
Hi George,
The main purpose of the model DB is to give you an easy way to insure
that all new datbases are created with the same options. But there are
also many DBAs that stick common "utility" tables in there, such as a
numbers table or a calendar table. Your use is less common, but still
correct use of the model DB.
--
Hugo Kornelis, SQL Server MVP
Navigation:
[Reply to this message]
|