My concern is with SSRS. Will installing SSMS for 2008 R2 Express change, in any way, our ability to work with SSRS for SQL Server 2005?

I think potential still rules, at least with a significant number of companies. I knew a gal who I worked with some years ago, that was brilliant at school....

t.brown 89142 (10/9/2012)

---

I tried this as I have SSMS 2005 and SSMS 2008 R2 installed on the same machine.

opening SSMS 2005, I CAN connect to the 2008 R2 database.

When I...

I've heard that triangle put differently: time, cost and features. We're embarking on a major re-write of a legacy app. Before we started on this I had plans...

No SQL Server t-shirts from any vendor or Microsoft. (I'm a developer first, and an accidental DBA second.)

Several MSDN t-shirts (I've no idea how many) and a couple of...

Good article, Steve, with a lot of interesting points. In my current job situation we're way too short staffed to be able to take much time off to do...

Thanks, Bob.

Dang, that is sweet. I guess I'll have to develop some logic to filter on the largest media_set_id for the backups I'm interested in. Before I go too...

WOW, good explanation, Celko! I hope that one day we'll be able to upgrade to SQL 2008 R2 or SQL 2012. Fortunately for me, this was an ad...

GSquared (8/27/2012)

---

UPDATE/DELETE FROM work in all versions of SQL Server that I've worked with, including SQL 2000, 2005, 2008, and 2012. MS isn't planning on removing them. If...

Lynn Pettis (8/27/2012)

---

Rod at work (8/27/2012)

---

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE...

Oh, really? I got the impression, from the Connect article, that UPDATE FROM wasn't a part of the ANSI standard. That MERGE was to be favored; and...

For me, it is overwhelmingly in favor of "Fix".

Thanks.

IowaTechBear (8/3/2012)

---

We have a few hundred databases spread across our state in multiple data centers. Our standard backup policy (to Tivoli TSM) is a weekly full backup, nightly differentials and...