How to generate script for database mail?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  October 18, 2011 at 8:36 am

  #246669

  Many thanks in advance.

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  October 18, 2011 at 8:41 am

  #1396022

  to send or enable database mail?

• Steve Cullen

  SSCertifiable

  Points: 5598

  More actions

  October 18, 2011 at 8:43 am

  #1396030

  EXEC msdb.dbo.sp_send_dbmail

  Check BOL for the arguments you need.

  Converting oxygen into carbon dioxide, since 1955.

• Lowell

  SSC Guru

  Points: 323522

  More actions

  October 18, 2011 at 8:50 am

  #1396037

  by the topic, it sounds like he wants to script out the database mails ettings, not how to send database mail.

  my old post here has an awesome script for that:

  Script Out Database Mail Settings?

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!