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...

Thanks, Jack, I'll get rid of those things.

Hi Mike and It's The Database,

Your reply, Mike, made me realize that I left out some important details. Our current SQL 2005 database is on a server on-premise. The new...