Share via

Is it really the released version of SQL Server 2008?

  • Article

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:

image

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

clip_image001_2

Comments

  • Anonymous
    August 18, 2008
    PingBack from http://housesfunnywallpaper.cn/?p=1228

  • Anonymous
    September 07, 2008
      After downloading  & installing SQL Server 2008 RTM,  When you use SQL Server Management

  • Anonymous
    November 22, 2008
    Hi, I have the version above, 10.0.1600.22 ((SQL_PreRelease).080709-1414) but short cuts like F8 for Object Explorerand CTRL-N for new query are not available, why is that? Thanks, Chris

  • Anonymous
    February 18, 2009
    Come on guys... leaving the internal branch name to show up on the about screen? Is that a sloppy job or what?!?!?!

  • Anonymous
    July 10, 2010
    To Chris's question above about missing keyboard shortcuts - I believe that Alt-N will now open a new query window. The Ctrl-N option seems to be a SQL 2000 shortcut.  I have found that I can get that option back though by briefly enabling the SQL Server 2000 keyboard scheme and then setting it back to standard.  (Tools, Options, Environment, Keyboard - Change Keyboard scheme to SQL Server 2000, OK, notice Ctrl-N works - then if you want to change it back, repeat the steps and set it to Standard)

  • Anonymous
    March 26, 2014
    What edition does 10.3.5500.0 map too? Developer, Std, Enterprise? Or all 3? Thanks,         Van