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

HanShi (9/5/2013)

---

The RAISERROR command in your trigger raises an error with a user defined number. This error is not a standard SQL error, but RAISERROR can still be done in...

It seems pretty unanimous. I'll uninstall SQL 2008 R2 Dev. Ed, and put in SQL 2012 Dev. Ed. (Thank you, Gail, for pointing out that there's no 2012 R2.)