http://www.sqlservercentral.com/Articles tagged T-SQL, Advanced Querying, Monitoring posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL. http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/2005/02/18http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/Have you ever had the problem where a user ran a query against your SQL Serer and crashed it or made the server unusable since the CPU was spiked at 100%? A SQL Server black box is the equivalent of a flight data record. The black box records all queries being passed to your SQL Server and other useful information like errors. http://www.sqlservercentral.com/articles/Administering/blackbox/954/2003/04/11http://www.sqlservercentral.com/articles/Administering/blackbox/954/Ever been placed into a new environment and couldn't find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.http://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/2002/04/02http://www.sqlservercentral.com/articles/Security/newenvironmentparti/653/Running a script automatically from SQL Server is easier than you think. Here are a few methods you can use. http://www.sqlservercentral.com/articles/Administering/scriptscheduling/450/2001/10/17http://www.sqlservercentral.com/articles/Administering/scriptscheduling/450/Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL. http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/2005/02/18http://www.sqlservercentral.com/articles/Advanced+Querying/xp_sendmail/369/