Thank you, that was very useful. I've run the SELECT statement that you gave me in msdb and here's the results:

The mail could not be sent to the recipients because...

John Jakob (10/14/2013)

---

Like the other poster said, what happens when you try sending a test email?

If you try something like this:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'DBMailPublicProfile', ...

Thanks!

Thank you, this does help, but I wonder about setting up an on-premise SMTP server? We didn't have to do that before, when we had...

Thank you!

We have now migrated to SQL Server 2012, with SSRS 2012. Does SSRS 2012 allow for multiple sorts, or do you still suggest that we use a report parameter?

Just an addendum, the more I think about this, the less I think that I actually had a disk for service pack 1 for SQL Server 2008 R2. I believe...

Thank you, Koen and Grant.

Thank you, Gail, for your answer. Now I'm trying to work out the correct syntax. It looks as though I should use the GRANT statement. I've created a custom role...

Hi Gail,

I'm confused, I'm sorry. I thought that the MSDN article that Bhuvnesh pointed to said that you could...

OK, Bhuvnesh and Gail, I've created a new role, but adding db_datareader and db_datawriter has me stumped. I've tried doing it through the SSMS GUI, but it won't let me,...

Very interesting article, Andy!

Gary Varga (9/26/2013)

---

I totally agree. With everything.

I am in full agreement that anyone working on the MS stack needs to know PowerShell. I myself have been using it on and...

I don't really fit into the environment you've described, Steve, but we do, kind of. We're an IT staff of 2 people, having experienced dwindling budgets and reductions in staff...

Jack Corbett (9/12/2013)

---

While it isn't ideal because it requires the report to be re-run if they change the parameter, I usually implement this with a Sort By parameter...