Script out EXISTING database mail profile's settings

Question

Post reply

Script out EXISTING database mail profile's settings

Subhash Chandra

Say Hey Kid

Points: 692
More actions
April 23, 2018 at 11:19 am

#328479

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

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

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

terry.home Ten Centuries Points: 1004 More actions · Answer 1

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

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 2

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)

Subhash Chandra Say Hey Kid Points: 692 More actions · Answer 3

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

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 4

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)

Dave at Work Grasshopper Points: 19 More actions · Answer 5

Dave at Work

Grasshopper

Points: 19

January 28, 2020 at 10:11 pm

#3721038

Good script, thanks for posting it !!!!

reka_liebe SSC Journeyman Points: 90 More actions · Answer 6

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