x

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?

more ▼

asked Jul 23, 2010 at 04:06 AM in Default

avatar image

Kev Riley ♦♦
66k 48 63 81

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jul 23, 2010 at 08:26 AM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

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.

Jul 24, 2010 at 03:23 PM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

Buried deep in the online documentation for SSMS is a section entitled "New Scripting Capabilities"... This is the nearest thing I can find to what you're looking for.

more ▼

answered Jul 23, 2010 at 04:19 AM

avatar image

ThomasRushton ♦♦
41.9k 20 50 53

  • 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" !!!

Jul 26, 2010 at 01:10 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2175
x776
x159
x8

asked: Jul 23, 2010 at 04:06 AM

Seen: 3365 times

Last Updated: Jul 23, 2010 at 04:06 AM

Copyright 2017 Redgate Software. Privacy Policy