Top "Sp-send-dbmail" questions

`sp-send-dbmail` is a built-in stored procedure available in SQL Server since 2005, which allows one to send e-mails using the SQL service, for alerting a DBA when a problem is detected or limited reporting.

How to send mail from Stored Procedure?

I need to send a mail from Stored Procedure. I knew it is possible. I studied it from this link . …

sql stored-procedures email sp-send-dbmail
sp_send_dbmail attach files stored as varbinary in database

I have a two part question relating to sending query results as attachments using sp_send_dbmail. Problem 1: Only basic .…

sql sp-send-dbmail
Clearing db mail queue in sql server

My DB server seems to be stuck in some kind of a trance. When I run a query, it runs …

sql-server sp-send-dbmail
Stored procedure using sp_send_dbmail to send emails to multiple recipients queried from database

Like the title says, I'm trying to make a stored procedure used to send emails to addresses stored in the …

sql sql-server database stored-procedures sp-send-dbmail
sp_send_dbmail - formatting row in table as red for an alert

I'm using something similar to example C on this MSDN page: http://msdn.microsoft.com/en-us/library/ms190307.aspx DECLARE @…

html tsql sql-server-2008-r2 sp-send-dbmail
sql server sp_send_dbmail

I am using SQL Server's sp_send_dbmail stored procedure to send mail via the database. But when I execute …

sql-server sp-send-dbmail
sp_send_dbmail will not send query results

I've tried every avenue on every damn forum suggested, but to no avail! Need to send results of SQLPERF(logspace), …

sql-server temp-tables sp-send-dbmail
How can I use sp_send_dbmail to send multiple queries?

I'm trying to send an email using sp_send_dbmail. I need it to send one query as an attachment …

sql sql-server sql-server-2005 tsql sp-send-dbmail
Only some e-mail gets sent successfully from sp_send_dbmail (Database Mail) on SQL Server 2005

I want to find an answer to what is happening when I use sp_send_dbmail on SQL Server 2005. I …

sql-server-2005 sp-send-dbmail database-mail
Send email from SQL server for each row of a dataset

I have built a stored procedure for sending an email reminder to a set of employees each week. The SQL …

sql sql-server email sp-send-dbmail dbmail