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
No comments:
Post a Comment