Detach the database, copy the .ldf and .mdf files to the target machine and attach them.
>Hi.
>I have set up a Sql Server 2005 database on my machine.
>I now want to set up/copy the database and tables etc to the client computer, who is running Sql Server express.
>
>I'd appreciate pointers on how thi can be achieved ?
>
>Regards,
>Gerard
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer