SQL Server 2005 Build Numbers

Since Microsoft released SP2 for SQL Server 2005, there have been several publicly available updates and hotfixes, so it can become confusing about what build you are on (and what it includes). Here is a partial list of common SQL Server 2005 Builds:

Description                                                                                Build Number

SQL Server 2005 RTM                                                                  1399

SQL Server 2005 SP1                                                                   2047

SQL Server 2005 SP2 (Before March 5)                                        3042

SQL Server 2005 SP2 with Maintenance Plan fix                         3050

SQL Server 2005 SP2 with Cumulative Hotfix (KB933097)            3152

SQL Server 2005 SP2 with Hotfix 3159 (KB934459)                      3159

 

The two scripts below let you programatically retrieve version information.

— Get complete version information
SELECT @@VERSION

— Get Version, SP and Edition
SELECT SERVERPROPERTY(‘productversion’) AS ‘Build’, SERVERPROPERTY (‘productlevel’) As ‘Level’,
SERVERPROPERTY (‘edition’)As Edition

Technorati Tag: SQL Server

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

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