Send Binary file stored in sql server as email attachment

  • Hi,

    Is there a way to send binary file stored in SQL Server as email attachment without downloading it to the file system?

  • Not that I'm aware of.

    Some way you have to download the file to the filesystem, using BCP, a custom application or a CLR procedure.

    However, DBMail doesn't look to me like a good fit for this task. DBMail works well for administrative emails and alerts.

    Messages for end users are best handled by application servers (which also have cheaper licensing than SQL Server).

    -- Gianluca Sartori

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply