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 |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2012-01-27 : 07:53:27
|
| Hi there,I'm not quite sure what category this falls into but here goes...We have a database that imports files such as documents, PDFs etc. and stores then as binary in an SQL image field type. I was wondering if there was an easy way to do this in reverse - I.E. read the binary from the field and recreate the original files onto disk?Any ideas?Thanks,Matt |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-01-27 : 09:08:23
|
| you can bcp them out with native file format.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2012-01-27 : 11:04:59
|
| Thanks Charlie, I'll give that a go. |
|
|
|
|
|
|
Writing files from binary image fields