Paul, thank you for the information.  I would like to go with CDO exclusively but can't because I will lose the SQL AGENT mail notification.  And I would like to have the...

Ok, I have come up with at T-SQL DMO solution.  There must be an easier why.  Here is my solution. If this code can successfully connect to a linked server it...

Kathi - For some reason this method does not work in my environement. When I run your code I get the following error message and the print statement "an error...

Thank you for all your advice.  I think I am just going to implement a SMTP solution, since our security and admin staff are concerned about POP3.

Looks like a number of you see that the Ethereal product is stable, and safe to install.  Thank you for your advice and information.  Think I will download this product.

Thank you for bringing this to my attention.  I wonder about products that are still in beta.  Who wants to provide an opinion as to whether they would install this...

Actually I want to use POP3 and SMTP mail to support our servers.  I want to be able to use xp_sendmail only.  I suppose I can deny access to all...

Thanks for all your suggestions so far.  Do any of you have any security scanning requirements you used to measure whether one tool was better than the other.

Juilian thats for the tips on the free products from Microsoft.   Is any one using any Third Party Products?

Thank you for those.  I'm sure there most be a number of other requirements.  Is anyone actually using any tools (canned or homegrown) to scan SQL Server for security risks?

Thank you this works great.

Thanks for the tips.  It doesn't appear to be the nic or at least I don't see any event log messages.  It does appear to be a single machine, so I'm...

In our environment, just because you are the CEO, doesn't mean you get access to everything that already exist, and anything new that comes down the road.  Basically the CEO...

Here is my take.

These roles allow the users in these roles to automatically get access to new objects in the database.  This is a drawback if your security model dictates...

Thank you for all the comments.  This has been extremely helpful, since I have been tasked with developing Database Administration Standards at company. 

Now I'm looking for a quick win...