Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 export documents in database

Author  Topic 

rbh123456789
Starting Member

15 Posts

Posted - 2011-08-31 : 09:31:16
using sql server 2005.

Can someone tell me how to 'download' (or export) all the documents from a certain table within a database using SQL Server Management Studio?

One record, for example, in the Documents table has a column named 'TEXT', which appears to be have the file contents in varbinary format(?)

any help would be appreciated. thanks.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-08-31 : 13:46:36
This article is specific to images but would apply to any binary content:
http://www.sqlteam.com/article/images-and-sql-server

This link states an opinion I completely agree with:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17742


Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -