How check my database mail id is created

• vivekinmadar

  Right there with Babe

  Points: 745

  More actions

  December 24, 2011 at 10:37 am

  #148935

  Hi

  Today i configured the database mail in sql sever 2005

  So please tell me which are the tables or views i have check whether my database mail is craeted

  Vivek

• salum

  SSCommitted

  Points: 1598

  More actions

  December 24, 2011 at 11:27 am

  #1425353

  Here is a simple query.

  SELECT *

  FROM msdb.dbo.sysmail_account a

  JOIN msdb.dbo.sysmail_server s

  ON a.account_id = s.account_id

  JOIN msdb.dbo.sysmail_servertype st

  ON st.servertype = s.servertype

  http://msdn.microsoft.com/en-us/library/ms177580(v=sql.100).aspx

  java[/url]