is this a SQL DB?
if so how can I export it into a text file?
the .mdf file is on my C:\ currently.
I archived it from my Websense app.

thanks

Antz

In message <1de201c42715$b0f61410$a001280a (AT) phx (DOT) gbl>, Antz
<anonymous (AT) discussions (DOT) microsoft.com> writes
MDF is the default extension for SQL Server database data files. Do you
have a LDF files as well? If so lookup sp_attach_db in Books Online. If
you only have one files, then try sp_attach_single_file_db, but be
warned this may not work unless the files where detached cleanly.

This allows you to attach the files to a SQL Server, from which you will
then be able to export the data from the database, perhaps via BCP or
DTS. You cannot convert a mdf file to a text file directly.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org