Post reply

find out Database Mail or SQL mail configuration

  • January 27, 2009 at 6:33 pm

    #196482

    Is there a way to find out database mail or SQL mail configuration info from the system tables?

    I mean via query instead of clicking GUI.

  • January 27, 2009 at 9:03 pm

    #933608

    Microsoft has provided a complete set of Database Mail Configuration Stored Procedures

    If the configuration stored procedures don't meet your needs, you can take a peek inside the stored procedures and see there are a whole series of sysmail_* tables in msdb

  • January 28, 2009 at 9:22 am

    #933917

    Thank you Ken. It works for database mail (SQL2005), but not for SQL mail (SQL2000). I also need to find out those info from SQL2000. Any idea?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply