how to recover an MDF without the LDF file?

A database's log file (ldf) has been lost and no backup
exists. I still have the data file (mdf). Does anyone
know how I can recover the mdf without having the ldf?
Charlie CunninghamTry using sp_attach_single_file_db.
Also refer to following url
Attaching .MDF file when transaction log is corrupt
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
--
-Vishal
"Charlie Cunningham" <charliec2@.cox.net> wrote in message
news:099a01c36d8c$ab99ac90$a001280a@.phx.gbl...
> A database's log file (ldf) has been lost and no backup
> exists. I still have the data file (mdf). Does anyone
> know how I can recover the mdf without having the ldf?
> Charlie Cunningham|||Vishal,
Your recommended solution worked like a charm.
sp_attach_single_file did not work...it kept wanting the
original log file noted in the MDF internal info.
Thank you for your assistance.
Charlie
>--Original Message--
>Try using sp_attach_single_file_db.
>Also refer to following url
>Attaching .MDF file when transaction log is corrupt
>http://www.sqlservercentral.com/scripts/scriptdetails.asp
?scriptid=599
>--
>-Vishal
>"Charlie Cunningham" <charliec2@.cox.net> wrote in message
>news:099a01c36d8c$ab99ac90$a001280a@.phx.gbl...
>> A database's log file (ldf) has been lost and no backup
>> exists. I still have the data file (mdf). Does anyone
>> know how I can recover the mdf without having the ldf?
>> Charlie Cunningham
>
>.
>