A little help moving my database

Hi everyone,
I need a little bit of help with the following.
I have a fairly small database at work that is contained in an SQL Server. I
want to get that database - inc tables, stored procedures and data on to my
SQL Server running at home.
I need to somehow get all the information onto a cd and take it home. But
I'm not sure how I should copy the database. Is it possible just to copy the
data files from the work computer and somehow import them into the target
SQL Server? Would that include the Stored Procedures?
Many thanks all
SimonRead into sp_detach_db and sp_attach_db. Provided you are using SQL
7/2000/MSDE, it will allow you to detach your database so you can bring the
.mdf, .ndf and .ldf files home and reattach them.
Note if you have SQL 7 at home, not only does the database have to be SQL7
format but the sort order of the source and destination server must be
identical, use sp_helpsort to find out. If you are SQL 2000/MSDE you are
gold.
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
This is the link to Microsoft's available product info download.
--
*******************************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
*******************************************************************
"Simon Harvey" <simon.harvey@.the-web-works.co.uk> wrote in message
news:uD8MUYc5DHA.2572@.TK2MSFTNGP09.phx.gbl...
> Hi everyone,
> I need a little bit of help with the following.
> I have a fairly small database at work that is contained in an SQL Server.
I
> want to get that database - inc tables, stored procedures and data on to
my
> SQL Server running at home.
> I need to somehow get all the information onto a cd and take it home. But
> I'm not sure how I should copy the database. Is it possible just to copy
the
> data files from the work computer and somehow import them into the target
> SQL Server? Would that include the Stored Procedures?
> Many thanks all
> Simon
>