If you want to copy the entire database, it is pretty easy using the SP_DETACH_DB and the SP_ATTACH_DB stored procedures.

What you do is:

1) On the Server where the database is, run SP_DETACH_DB passing in the correct parameters. (No one can be logged in when this is executed.)

2) Go to you SQL Server data folder and copy the data files (there will be a MDF and possibly and LDF file) for that database to your other SQL Server's data folder.

3) Run SP_ATTACH_DB on both Servers (passing the correct parameters) to (re)attach the data files to the Server.

No you have the database on both servers!

>Newbie question, part deux -- how do I copy the stored procedures from the first database to the new one?
>
>Marie