 |
(Tim Ford) One of the most welcome SQL Server 2005 enhancements over its predecessors is Database Mail. Database Mail is built on the Simple Mail Transfer Protocol (SMTP) as compared to SQL Server 2000 Mail which used a buggy and temperamental MAPI client causing significant frustration. Just like with everything else, every enhancement comes with its own learning curve. If you're new to Database Mail in SQL 2005 it is quite easy to get lost somewhere between the Surface Area Configuration Tool (where Database Mail is enabled) and SQL Server Management Studio (where the settings for Database Mail configured). I'll show you the basics of getting Database Mail configured for basic use in Management Studio and then show you a much quicker method via T-SQL. You'll be able to get Database Mail running in under a minute once this script is customized for your environment. At the end of this tip we will review a few of the most common stored procedures associated with Database Mail and compare them to their SQL Mail stored procedure equivalents. |
