Is it really the released version of SQL Server 2008?

Published Jan 15 2019 11:00 AM 45 Views
Microsoft
First published on MSDN on Aug 18, 2008

The following is a question we have received from a few folks who were concerned after installing SQL Server 2008 that they did not have the final released build. When you use SQL Server Management Studio and select the Help/About menu choice to see what version you have, you may see something like this:

Notice the Versions column and the string for the first and second "rows". It says 10.0.1600.22 ((SQL_PreRelease)... So what does SQL_PreRelease mean? Don't I have the "released" SQL Server and not some pre-release? The string SQL_PreRelease is just an internal name we use for a branching and directory structure as we built the product. It does not mean a pre-released version of the software. If the version says 10.0.1600.22 then you have the the final RTM product installed on your computer.

In fact, the official @@version string looks like this on SQL Server 2008 RTM x64:

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64)
Jul  9 2008 14:17:44
Copyright (c) 1988-2008 Microsoft Corporation

Bob Ward
Microsoft

%3CLINGO-SUB%20id%3D%22lingo-sub-315518%22%20slang%3D%22en-US%22%3EIs%20it%20really%20the%20released%20version%20of%20SQL%20Server%202008%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315518%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Aug%2018%2C%202008%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThe%20following%20is%20a%20question%20we%20have%20received%20from%20a%20few%20folks%20who%20were%20concerned%20after%20installing%20SQL%20Server%202008%20that%20they%20did%20not%20have%20the%20final%20released%20build.%20When%20you%20use%20SQL%20Server%20Management%20Studio%20and%20select%20the%20Help%2FAbout%20menu%20choice%20to%20see%20what%20version%20you%20have%2C%20you%20may%20see%20something%20like%20this%3A%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66131iE823809788F4944F%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3ENotice%20the%20Versions%20column%20and%20the%20string%20for%20the%20first%20and%20second%20%22rows%22.%20It%20says%2010.0.1600.22%20((SQL_PreRelease)...%20So%20what%20does%20SQL_PreRelease%20mean%3F%20Don't%20I%20have%20the%20%22released%22%20SQL%20Server%20and%20not%20some%20pre-release%3F%20The%20string%20SQL_PreRelease%20is%20just%20an%20internal%20name%20we%20use%20for%20a%20branching%20and%20directory%20structure%20as%20we%20built%20the%20product.%20It%20does%20not%20mean%20a%20pre-released%20version%20of%20the%20software.%20If%20the%20version%20says%20%3CSTRONG%3E%2010.0.1600.22%20%3C%2FSTRONG%3E%20then%20you%20have%20the%20the%20final%20RTM%20product%20installed%20on%20your%20computer.%3C%2FP%3E%0A%20%20%3CP%3EIn%20fact%2C%20the%20official%20%40%40version%20string%20looks%20like%20this%20on%20SQL%20Server%202008%20RTM%20x64%3A%3C%2FP%3E%0A%20%20%3CP%3EMicrosoft%20SQL%20Server%202008%20(RTM)%20-%2010.0.1600.22%20(X64)%20%3CBR%20%2F%3E%20Jul%26nbsp%3B%209%202008%2014%3A17%3A44%20%3CBR%20%2F%3E%20Copyright%20(c)%201988-2008%20Microsoft%20Corporation%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EBob%20Ward%20%3CBR%20%2F%3E%20Microsoft%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F66132i920D9FBAFDDB662E%22%20%2F%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-315518%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Aug%2018%2C%202008%20The%20following%20is%20a%20question%20we%20have%20received%20from%20a%20few%20folks%20who%20were%20concerned%20after%20installing%20SQL%20Server%202008%20that%20they%20did%20not%20have%20the%20final%20released%20build.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-315518%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESetup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%202008%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 11:00 AM
Updated by: