I made a dynamic proc which turns any random query into an HTML table, so you don’t have to hardcode columns like in the other responses. — Description: Turns a query into a formatted HTML table. Useful for emails. — Any ORDER BY clause needs to be passed in the separate ORDER BY parameter. — … Read more
You need to grant the user or group rights to use the profile. They need to be added to the msdb database and then you will see them available in the mail wizard when you are maintaining security for mail. Read up the security here: http://msdn.microsoft.com/en-us/library/ms175887.aspx See a listing of mail procedures here: http://msdn.microsoft.com/en-us/library/ms177580.aspx Example … Read more
Step 1) Create Profile and Account You need to create a profile and account using the Configure Database Mail Wizard which can be accessed from the Configure Database Mail context menu of the Database Mail node in Management Node. This wizard is used to manage accounts, profiles, and Database Mail global settings. Step 2) RUN: … Read more