Script out EXISTING database mail profile's settings

  • Comments posted to this topic are about the item Script out EXISTING database mail profile's settings

  • Excuse my ignorance, not having used 2016 yet in anger, why would you need to do this?

  • terry.home - Wednesday, May 2, 2018 3:24 PM

    Excuse my ignorance, not having used 2016 yet in anger, why would you need to do this?

    To stand up another box more easily.  I don't use such a thing, though, because I prefer to use CDOSYS even after all these years.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Hi Jeff,
    Thanks for your comments, I think its Individual choice and way of working, with how minimum down time you want to move your server.   

    Thanks
    Subhash

  • Subhash Chandra - Friday, July 6, 2018 12:54 AM

    Hi Jeff,
    Thanks for your comments, I think its Individual choice and way of working, with how minimum down time you want to move your server.   

    Thanks
    Subhash

    Just to be sure, in no way was my suggestion of using CDOSYS an argument against you or your good article.  It was only meant as an alternative, especially if there's a reason why mail couldn't be setup using traditional methods.  An example of such a reason is in older fail-over clusters where the people large-and-in-charge won't do a fail-over so you can setup email on the fail-over node(s) but you still need email to work.  I've had to use it so many times at so many companies so that the "DBA Morning Reports" that I build for folks will actually work for sure that it's become a bit of a de facto standard for me.  If traditional methods work for whatever system you're trying to stand up, then your good scripts will be mighty handy.  Thank you for taking the time to write and publish the article about them.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Good script, thanks for posting it !!!!

  • Hi Is this the same script publish on technet? original link already removed i only can access it with archive.org

    https://web.archive.org/web/20200318050435/https://gallery.technet.microsoft.com/scriptcenter/Script-to-Scipt-out-14a19eda

     

     

Viewing 7 posts - 1 through 6 (of 6 total)

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