Is it really the released version of SQL Server 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:

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 (6)

  1. Amit's blog says:

      After downloading  & installing SQL Server 2008 RTM,  When you use SQL Server Management

  2. chrisplasun@hotmail.com says:

    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

  3. Gustavoc says:

    Come on guys… leaving the internal branch name to show up on the about screen? Is that a sloppy job or what?!?!?!

  4. DaveClark says:

    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)

  5. A corollary question says:

    What edition does 10.3.5500.0 map too? Developer, Std, Enterprise? Or all 3?

    Thanks,

            Van