Forum Replies Created

Viewing 15 posts - 16 through 30 (of 98 total)

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    I have many scenarios for using SQL server to send the mails. None of mine yet have used a batching method since the recipient list is pretty small.

    1. Data integrity...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Gift Peddie (5/27/2010)


    This then runs at a particular interval as a scheduled task and I keep our Exchange Admin from breathing down my neck.

    This relates to what I was saying...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Mike-1076638 (5/27/2010)


    select * from subscribers where subscription_date=getdate()-365

    Easy Peasy

    Mike

    DB Software Laboratory

    ETL Tools for everybody

    Well, that was my point with the purely fixed distribution list on the mailserver. I was...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    alen teplitsky (5/27/2010)


    as a former email admin, why not just let MS Exchange handle the work. create some custom receipients that are hidden from the corporate address book and a...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Time Bomb Design - A Longer Fuse

    Cinderella data users!

    Oh how I laughed so long I cried.

    The actual crying is pretty much done with now. That was almost the entire company when I joined. Every department with...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Aye. There are better things to do with a DB system than use it as a mass mailer and better systems for doing so but sometimes, if you have a...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Ahh, I see where you are going there. If Mcafee was monitoring an email client and an external program tried to connect via the back end of the client then...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    One simple way is not to use Mcaffee. Sorry but that's just it.

    Besides if it is flagging a plain html email with no attachment as a virus then there is...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Outlook and Notes are clients (not sure if Notes server is called that).

    Mine is set to send via MS Exchange though any email server software such as sendmail would do....

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Sending HTML Newsletters in a Batch Using SQL Server

    Nice article and it made me look back at some stuff I had done a while back and re-jig it to fit in with this.

    I took a slightly different take...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Job Status Report with Error Detail

    The one bit in my script that people might find useful in the one from the article is the conversion from the silly* integers to real dates.

    The below is actually...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Job Status Report with Error Detail

    Nice one. Where was this a couple of weeks ago when I was looking to build a job dashboard.

    I actually ended up taking things to bits, breaking it down and...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Convert String to a Table using CTE

    Jonathan Melo (12/14/2009)


    Rob Fisk (12/14/2009)


    Pretty certain I found this based on another article here somewhere but cannot find it to give credit.

    I believe that must be a Jeff Moden article,...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Convert String to a Table using CTE

    Always good to see different ways of approaching things. Will have to have a look at the issue with the single item here and then maybe set up some performance...

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

  • RE: Exporting to Excel Using a CLR Stored Procedure

    Brad Chapman-387295 (12/8/2009)


    The extension hardening got a little harder trying to name file with xlsx extension.

    When I change C# source to have xlsx extension the Excel file will not open....

    [font="Arial"]_______________________________________________________
    Change is inevitable... Except from a vending machine.[/font]

Viewing 15 posts - 16 through 30 (of 98 total)