You could also take a backup and restore it.
Probably the most common approach is with a set of scripts. I once worked with a commercial product that had a seperate utility for installing and maintaining the database. I really like this approach.
-Mike
>MSSQL Server 2000 database
>
>I am looking for some ideas on how to install the database in the customers SQL server.
>
>Generate Script - then use
>OSQL
>Use SPT to execute everything between the GOs
>Detach/Attach DB
>
>Any examples are appreciated...
>Pros/Cons
>
>I would like this to be somewhat automated.
>I dont want to open the script in Query Analyzer and run it.
>
>Thanks in advance
>Jerimi