Export actual files from SQL Server

[cmv131]

Hi all,

I am trying to extract our "Attachments" table out to actual files. When a user uploads an attachment, the system we are using adds it to the database as a blob field.

Is it possible to extract them to actual files from the table?

 

[NoCoolHandle]

Without writing a specific app for it..

SQLserver comes with a textcopy.exe utility (bin directory)
read..

http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

HTH

Rob