Hey guys and galls,
First time poster long time reader. I think I'll definitely have to become a part of the community.
What I'm trying to do:
Programmatically script a SQL Server 2000 database. I'd like to script everything from tables to stored procedures.

What I need To Do It By Code:
We role out new patches to hundreds of websites on a weekly basis. Along with having to keep all the running websites up to
date, we have to keep our script which creates new sites up to date as well.
We currently have a sql script that generates our database, all the tables and stored procedures on the fly. We created this script
manually and have to keep updating it every time we push out a patch.
So I thought it may be easier if we keep a database on SQL which we keep up to date and use that to script every new site.

Could there be a better way?
Does anyone maybe know a better way we can do this? I detaching a database and copying it from one to another but
I think the problem there was that the database name was the same for every database.

Any help would be greatly appreciated.