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 |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-02-27 : 12:05:09
|
| Is it possible using xp_sendmail making an attachment of a blob object from database cell.I have a requirment to attach the files but the files are all under the table which is a blob object.Thank you very much for the information. |
|
|
yonabout
Posting Yak Master
112 Posts |
Posted - 2006-02-28 : 07:09:52
|
| I've just tried it against some signature images held as blob data on one of our databases. Using xp_sendmail, it creates a text file containing the binary code for the blob and sends that - renaming the file doesn't let you see the contents.I'm not sure what you're trying to use it for, but if I had to translate the blob back into an image, I'd use a vb app to convert it to its original format, and then attach the converted file - maybe you could trigger something using an activex in a dts package to do something similar??Cheers,Yonabout |
 |
|
|
|
|
|
XP_Sendmail Attachments blob object