Question: how to export blob data from sql server?
Answer: To export a BLOB field to file, you need a SQL Server utility called “bcp”, more info http://msdn.microsoft.com/en-us/library/ms162802.aspx. You can run bcp.exe from the DOS command line or within SQL Server Management Studio query window.