Post reply

Send subscriptions to email stored in the table

  • June 2, 2015 at 5:32 am

    #298717

    Hi,

    Could someone please advise if its possible to send subscriptions to email IDs stored in the table without the 'data driven subscriptions' feature ?

    Thanks.

  • June 2, 2015 at 5:41 am

    #1802248

    yes.

    on codeplex.com, there is free, available source code for at least two projects i know of that lets you do data driven subscriptions from SQL Standard instead of enterprise.

    my google-fu is failing me at the moment, but that's where to start.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 2, 2015 at 8:24 am

    #1802327

    Lowell (6/2/2015)

    yes.

    on codeplex.com, there is free, available source code for at least two projects i know of that lets you do data driven subscriptions from SQL Standard instead of enterprise.

    my google-fu is failing me at the moment, but that's where to start.

    Thanks Lowell.

    I have had a look at the code however it does not relate or helps if you need to send the subscriptions to email addresses stored in the tables.

    The only requirement I have in terms of data driven subscriptions is to automatically send subscriptions to the list of email addresses in the table.

    Thanks.

  • June 2, 2015 at 9:33 am

    #1802344

    Jason Selburg's article maybe?

    http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

Viewing 4 posts - 1 through 3 (of 3 total)

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