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.
| Author |
Topic |
|
MVB77
Starting Member
5 Posts |
 Posted - 2010-11-15 : 12:38:23
|
| Hello, I'm new to SQL Server and have a question regarding exporting binary data out of the database onto a server file system. I have a SQL Server 2005 DB (~150k rows, 45GB in size). Of the columns in the database DocID (PK, int), and FileData (varbinary(max)) are two columns int the table tblDocuments. I need to export each row's FileData and place inside a folder, named the DocID on a server file system. Does anyone know of a stored procedure to do this in bulk. I would like to have a way to break up the task into chunks, e.g. DocID 1->5000, DocID 5001->9999, etc... Thanks for your help. |
|
|
|
|
|
Exporting Binary Data