Showing posts with label deploy. Show all posts
Showing posts with label deploy. Show all posts

Tuesday, March 20, 2012

Script out dbmail configuration?

Is there any way to script out the dbmail configuration? It would be quite handy to have a script to deploy for uniformity across servers...

Currently it's quite a pita to have to configure dbmail by hand on every server.

Thank you.

That is a very nice request, I will file a design request on this.

Currently there are APIs (SMO and SPs) that exists to create a profile, account . You can use them to create a reusable script to run on multiple servers.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/58ae749d-6ada-4f9c-bf00-de7c7a992a2d.htm

Cut and paste the above link in BOL and you should be able to see sample script for this scenario.

Gops Dwarak

Script out dbmail configuration?

Is there any way to script out the dbmail configuration? It would be quite handy to have a script to deploy for uniformity across servers...

Currently it's quite a pita to have to configure dbmail by hand on every server.

Thank you.

That is a very nice request, I will file a design request on this.

Currently there are APIs (SMO and SPs) that exists to create a profile, account . You can use them to create a reusable script to run on multiple servers.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/58ae749d-6ada-4f9c-bf00-de7c7a992a2d.htm

Cut and paste the above link in BOL and you should be able to see sample script for this scenario.

Gops Dwarak