SQL Mail Audit

microsoft.public.sqlserver.programming

30 Jun 2006 4:45 PM

Rob

Hi,

In our company recently, two groups have merged and their SQL servers have
been acquired by our support team.

Some of the SQL servers acquired from the other group are configured to use
SQL Mail. Unfortunately, I've don't have the expertise with SQL Mail as I've
never used it.

At this time, we'd like to take an audit of all acquired servers that are
configured with SQL Mail. And I was wondering what options are available to
us. There are approximately 387 SQL servers that have been acquired
(physical, instances, and virtual). Is there a way to programmatically report
if a particular server is configured to use SQL Mail or not?

TIA.

Regards,

- Rob.