>>>>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.
>
>Can this be done by calling a single stored procedure?
>is so how?
>can you give a sample?
No this isn't an SP at all. If you could, I'd detach the db, make copies of all it's files and then reattach s you are back on line. Then move the copies to the new server and reattach again. Yoiu won't keep your logins between servers this way.