SQL Server version numbers
Our DBA recently installed a SQL Server 2008 instance and sent us admins off to the intarweb to find the corresponding version of Management Studio. This wasn’t needed as all the installation images are available on our CD archive but, still, I couldn’t figure out which version I needed.
Management Studio 2005 dutifully reported the version as “10.50.1600” but this version number wasn’t listed in the Google favoured MS KB “How to identify your SQL Server version and edition“.
I finally came across a useful listing of SQL Server 2008 version numbers on Glenn Berry’s blog in the article “SQL Server 2008 R2 RTM Cumulative Update 1 (Build 1702) Released“.