>>Is there another way to copy a database to another server without using DTS?
>
>You have a couple of options.
>1) Backup the database and restore it to the target server
>2) If you're using SQL Server 7.0, you can detach the database, copy the file to the target server, and attach the database to the target server.
>3) You can use the SEM to generate a script that will recreate the schema and use BCP to move the data (this could be a lot of work!).
>4) DTS with the Object Transfer option if you're going between SQL Server 7.0 servers.
>
>-Mike

Thanks for the info. I ended up detaching and re-attaching the database. It worked real well.