trying to figure out how to send multiple file attachments with sp_send_dbmail
- by Beta033
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