Any benefit of running SQL2008 R2 SSMS over SQL2008 SSMS

Question

question

Kev Riley asked Jul 23, '10

Any benefit of running SQL2008 R2 SSMS over SQL2008 SSMS

I don't have any SQL2008 instances for real, just one as a sandpit, but I use SQL2008 Management Studio for all my admin and dev tasks (excluding SSRS). Is there any benefit to installing SQL2008 R2 SSMS, or am I more likely to run into issues with my SSMS add-ins?

sql-server-2008 sql-server-2008-r2 ssms client-tools

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-07-23T08:26:40Z

Grant Fritchey answered Jul 23, '10

Based on all my testing... if you're not taking advantage of any of the functionality of R2, and there isn't much, then no, there's no real reason to do it. I'm not even sure all those "new" scripting capabilities are new. I sure didn't see anything in the XML that I've been pulling up.

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman commented · Jul 24, 2010 at 03:23 PM

The enhancements to SSMS 2008 over SSMS 2005 were quite substantial, but I am not aware of any major enhancements in SSMS 2008 R2 over SSMS 2008.

0 ·

Answer 2 · 2010-07-23T04:19:41Z

ThomasRushton answered Jul 23, '10

Buried [deep in the online documentation for SSMS][1] is a section entitled "New Scripting Capabilities"... This is the nearest thing I can find to what you're looking for. [1]: http://msdn.microsoft.com/en-us/library/ms174219.aspx

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Jul 26, 2010 at 01:10 AM

+1 - I was in two minds about this though. To vote up as you have been reading the documentation in such depth or vote down as you have clearly broken the unwritten rule that states "No Man Shall Read an Instruction Manual" !!!

1 ·

question