Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Script out dbmail configuration?

Domanda Script out dbmail configuration?

  • Monday, January 09, 2006 11:40 PM
     
     
    Sign In to Vote
    0

    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.

     

All Replies

  • Saturday, January 21, 2006 9:03 PM
     
     
    Sign In to Vote
    0

    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