> now, we're creating the database and tables in a fairly lengthy template
> and, every time we add a table or column, we have to modify the
> template. What I'd really like to do is have a standard database with
> all the tables, indexes, etc. but no data and then use that database as
> a template for creating a new user database.
>
> Is there an easy way to do this?
With SQL Server 2000, the "model" database is used to create new databases.
So, if you don't mind having all that stuff in every new database you
create, you can put it in there, I think.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
