MS SQL Server Version and Edition

Found a need to determine the Microsoft SQL Server 2005 version I was running.  On a rare occasion, I need to determine the SQL Server versions being used with our Corporate Applications.  Most of those installations are SQL Server 2000 with various Service Pack or Hot Fix levels.

Microsoft Support provides a document called “How to identify your SQL Server version and edition” to help you decipher the SQL Server version and edition you have installed.

SQL Server 2005

Release

Sqlservr.exe

RTM

2005.90.1399

SQL Server 2005 Service Pack 1

2005.90.2047

SQL Server 2005 Service Pack 2

2005.90.3042

SQL Server 2000

Release

Sqlservr.exe

RTM

2000.80.194.0

SQL Server 2000 SP1

2000.80.384.0

SQL Server 2000 SP2

2000.80.534.0

SQL Server 2000 SP3

2000.80.760.0

SQL Server 2000 SP3a

2000.80.760.0

SQL Server 2000 SP4

2000.8.00.2039

Update (12-Jul-2007)
Some information on this blog for those who may not have moved to SQL Server 2000 Service Pack 4.  It appears support for Service Pack 3a expired on July 10, 2007.

Advertisements

2 Responses to MS SQL Server Version and Edition

  1. Chris Grabowy says:

    Thanks for consolidating the SQL Server version info. I remember reading about it, and just today I needed to figure out if my 2005 installation had SP2 installed or not.

  2. mrothouse says:

    Chris,
    Thanks for checking this out. Glad it helped.

    Mike

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

%d bloggers like this: