THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Aaron Bertrand

Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.

How to really detect the version of SSMS you are running

Earlier this week, a hotfix was released that, among other thigns, addressed an issue where, if you restored a 2000 database from 2005 SSMS, it did not go well.  The KB article (KB #972687) says that only certain versions of SSMS are affected, and proceeds to list build numbers that are from cumulative updates, not major service packs.  As you may already know, Help|About in Management Studio only reflects the version of the last major service pack (or RTM), unless a cumulative update touches AppIDPackage.dll (which is apparently quite rare).  So even though changes in CUs (such as the one that caused this specific problem) update code that SSMS uses, SSMS itself does not indicate that it has been updated.  This was complained about in Connect #275512, which was incorrectly closed as not reproducible, even though Buck Woody openly admitted that this is true in both SQL Server 2005 and 2008.

At the urging of myself and a few others, Bob Ward has published a very comprehensive blog post about the restore database problem, and how to truly determine the version of SSMS you have installed (at least, if you know which file(s) you need to check; also a rare occurrence).  Rather than repeat what he wrote, I'll just link you there:

http://blogs.msdn.com/psssql/archive/2009/08/21/ssms-fails-to-restore-with-sql-2000-instances-and-ssms-versioning-explained.aspx

Published Friday, August 21, 2009 4:08 PM by AaronBertrand
Filed under: , , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

K. Brian Kelley - Databases, Infrastructure, and Security said:

In a recent forum thread , someone asked to see who created/altered a particular object. Starting in

August 21, 2009 3:37 PM
 

lnidba said:

Thank you for following up on this issue, I really appreciate it.

August 24, 2009 7:24 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About AaronBertrand

...about me...

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement