sql 2005 email archive

• BaldingLoopMan

  SSCertifiable

  Points: 6378

  More actions

  December 4, 2009 at 7:23 am

  #214355

  Trying to make sure i'm getting all the emails that it is trying to send to me. aRe the emails that sql server 2005 sends out from the msdb.dbo.sp_send_dbmail call stored anywhere? If so where?

• BaldingLoopMan

  SSCertifiable

  Points: 6378

  More actions

  December 4, 2009 at 7:25 am

  #1087703

  nevermind i found it. sysmail_mailitems

  INSERT sysmail_mailitems

  (

  profile_id,

  recipients,

  copy_recipients,

  blind_copy_recipients,

  subject,

  body,

  body_format,

  importance,

  sensitivity,

  file_attachments,

  attachment_encoding,

  query,

  execute_query_database,

  attach_query_result_as_file,

  query_result_header,

  query_result_width,

  query_result_separator,

  exclude_query_output,

  append_query_error,

  send_request_user

  )

  VALUES

  (

  @profile_id,

  @recipients,

  @copy_recipients,

  @blind_copy_recipients,

  @subject,

  @body,

  @body_format,

  @importance,

  @sensitivity,

  @file_attachments,

  'MIME',

  @query,

  @execute_query_database,

  @attach_query_result_as_file,

  @query_result_header,

  @query_result_width,

  @query_result_separator,

  @exclude_query_output,

  @append_query_error,

  @send_request_user

  )