Copy database

I'm new to SQL and I need help. We have a SQL 2000 server
and I need to copy the database and all its objects
(tables..) to another machine with MSDE version. Thanks
for any info.
you can take help of "backup database"/"restore database" commands. backup
your source database using "backup database" command(which is an online
operation) and restore it on the other databases with "restore database"
command. you can also also use system stored procedures sp_detach_db and
sp_attach_db. Use sp_detach_db procedure to detach the data/transaction log
files from the source database (database will not be available.) and attach
the required databases using sp_attach_db stored procedure.
See more help on above topics in books online.
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com