trying to figure out how to send multiple file attachments with sp_send_dbmail

Posted by Beta033 on Stack Overflow See other posts from Stack Overflow or by Beta033
Published on 2010-03-25T18:18:32Z Indexed on 2010/03/26 15:23 UTC
Read the original article Hit count: 344

Filed under:
|
|

MSSQL 2008

Maybe i'm just looking in the wrong place. Here's the scenario:

We have files stored in a varbinary(max) column. I'd like to select these as individual files, along with the names of the files stored nearby, as individual file attachments.

can this be done?

it's easy enough to send the results of a query as an attachment, but it just sends 1 file.

Thanks

© Stack Overflow or respective owner

Related posts about sql-server-2008

Related posts about sql