Hi

You don't actually say what the error is!

At a guess as you don't seem to be attaching the log file it could be
related to not finding the log. Try shipping both log and data files.

Alternatively you may have specified the wrong filename as your example
gives datafile and data_file!

John


"Leader" <sohelcsc@yahoo.com> wrote in message
news:b1a93c73.0307220458.345601c3@posting.google.c om...
> HI All,
>
> I want to ship the MSDE database with the software. To accomplish that
> i have two commands to run as far as i know
>
> 1. sp_detach_db 'db_name'
> 2. sp_attach_db 'db_name', 'c:\path\datafile'
>
> My question is after running the comman sp_detach_db then i have copy
> the datafiles of that database. Should i copy those datafiles directly
> from
> //Program Files\Microsoft SQL Server\MSSQL\Data\data_file
>
> or anywhere else...
>
> I am facing problem like if i copy the databafiles from the above path
> and try it to another MSDE database server then its giving me an
> error...
>
> Thanks in Advance
> Hoque