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

Interesting article, Steve. I take issue with one of your statements. You said, "Employees that dislike each other can bring down overall quality and coordination very quickly. The sooner managers...

It's more like:

Management Reports | Quarterly

I totally agree with what you said, Miles. When something goes wrong with software I've worked on, I always assume it's my fault and look at what's happening with it....

PhilipC (7/31/2013)

---

Has anyone noticed how vendor databases in general are getting worse and worse? It seems we're getting to an age where regardless of quality, it's just get the product...