.NET FAQs

Looking in .NET FAQs there is a thread on how to use the results of a stored procedure another on sql server memory management and the common question of how to get a stored procedure to send an email in sql server. Well the answer to that one is to use xp_sendmail. It is a bit tricky to setup the Outlook profile so that it will work properly but once it is configured it does the job well.