What Build of SQL Server 2008 Are You On?

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 SQL Server 2008 builds that were released after SQL Server 2008 was released

The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 1 was released

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.

Technorati Tags:

This entry was posted in SQL Server 2008. Bookmark the permalink.

3 Responses to What Build of SQL Server 2008 Are You On?

  1. Saggi says:

    Hi Glenn,This is probably the most exhaustive list of SQL Server builds (plus links to kb/download pages): http://sqlserverbuilds.blogspot.com/Cheers,S. Neumann

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s