question

Kev Riley avatar image
Kev Riley asked

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-2008sql-server-2008-r2ssmsclient-tools
10 |1200 characters needed characters left characters exceeded

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

Grant Fritchey avatar image
Grant Fritchey answered
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 comment
10 |1200 characters needed characters left characters exceeded

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

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 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
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 comment
10 |1200 characters needed characters left characters exceeded

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

+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 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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