Copy database to use for developement

I have recently made the migration to SQL from Access. I have been using a
database for the developement phase but now I need to copy the structure and
use it for the final product. I want to leave the existing database to use
for further development. What is the best route to copy and paste a database
from within the server? It will be only a copy of the structure, no data at
all. ThanksFor SQL Server 2000, use Enterprise Manager to generate the script.
Right-click on the database, select All Tasks --> Generate SQL Script.
In the Generate SQL Scripts dialog, click the Show All button and select the
objects (tables, stored procedure, functions, etc.) that you want to generate
scripts for. In the Options tab, select Script Database and any indexes and
keys you want to script. You can also script users, roles, etc.
Then run, or have the DBA run, this script on the target server.
"AkAlan" wrote:
> I have recently made the migration to SQL from Access. I have been using a
> database for the developement phase but now I need to copy the structure and
> use it for the final product. I want to leave the existing database to use
> for further development. What is the best route to copy and paste a database
> from within the server? It will be only a copy of the structure, no data at
> all. Thanks