Microsoft has a couple of handy KB articles that list the various public builds of SQL Server 2008 that were released after RTM and after SP1 respectively, which are listed below:
The easiest way to figure out what build your database engine is on is to run this command:
SELECT @@VERSION AS [SQL Version Info];
This query returns the following information on one of my test servers:
Microsoft SQL Server 2008 (SP1) – 10.0.2714.0 (X64) May 14 2009 16:08:52
Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit)
on Windows NT 6.1 <X64> (Build 7100:)
This tells me that I am running the x64 version of SQL Server 2008 Enterprise Edition SP1, with Build 2714 (SP1 CU2) on Windows Server 2008 RC RC1 (Build 7100). This is extremely valuable information for troubleshooting purposes. It tells me whether I am running x86 or x64, whether I am on Enterprise Edition, what operating system, and finally the exact build of SQL Server. BTW, the same command runs on previous versions of SQL Server.
This handy cheat sheet shows roughly how the builds are related to each other:
RTM Builds SP1 Builds
Build Description Build Description
1600 Gold RTM
1763 RTM CU1
1779 RTM CU2
1787 RTM CU3 –> 2531 SP1 RTM
1798 RTM CU4 –> 2710 SP1 CU1
1806 RTM CU5 –> 2714 SP1 CU2
Some of the fixes in RTM CU4 (1798) were included in SP1 RTM (2531), but some were not. If you are on 1798 or 1806, and you want to get on the SP1 branch (which is a good idea), you will have to install SP1, and then install the SP1 CU that corresponds with the RTM CU that you are on. BTW, CU stands for Cumulative Update, which is like a mini Service Pack that comes out every eight weeks. They are “cumulative”, so you don’t have to install each one sequentially.
For a new SQL Server 2008 installation right now, I would install off of the RTM DVD, which would give me Build 1600. Then I would install SP1, which would give me Build 2531. Finally, I would install SP1 CU2, which would give me Build 2714.
There is one very good reason to be on Build 2714 if you are using SQL Server 2008 Standard Edition, which is the fact that it includes the trace flag which allows you to enable “Lock Pages in Memory” on Standard Edition. You can get SP1 CU2 by going here and requesting it from Microsoft.