Are there any utilities to extract binary data from SQL Server?

Question

Are there any utilities available that allow you to bulk extract binary data from a SQL Server table?

For example, I have a number of Word documents stored in a table and I would like to extract all of these documents into files.

I know could do this by writing some .NET code, but I only need to do it once.

Answer 1

Yes, You can use bcp utility:

http://msdn.microsoft.com/en-us/library/aa174646(SQL.80).aspx

And this simple stored procedure:

http://jahaines.blogspot.com/2009/10/exporting-binary-files-to-file-system.html