THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

What Version of SQL Server Am I Running?

I frequently see questions like this – ”I am getting different version numbers for my SQL Server 2000 instances. All I'm aware of is 8.00.2039 - which is SP4.  These are these values I am getting, e.g. 8.00.2039, 8.00.2040, and 8.00.2148”?


Here are two great resources to help you out in the future:


Be sure to add them to your Favorites! 





Published Tuesday, August 5, 2008 1:14 PM by KKline
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Norman said:

August 5, 2008 2:20 PM

KKline said:

Awesome, thanks!  I really like Chip's site and stop by frequently.


August 5, 2008 2:33 PM

Remus said:

There is also an MS KB article at

August 5, 2008 2:53 PM

AaronBertrand said:

I had been maintaining a build list for SQL Server 2005 as well; however, the site is no longer my property.  The list looks really small right now, but it's due to an HTML error... I've contacted the owner and hope that it gets resolved soon.

August 6, 2008 12:58 PM

John Paul Cook said:

If you retrieve your SQL Server 2000 and above version information as text instead of into the SSMS grid control, use syntax similar to the following to reduce the enormous quantity of superfluous whitespace:

SELECT substring(cast(SERVERPROPERTY('productversion') as nvarchar),1,16),substring(cast(SERVERPROPERTY('productlevel') as nvarchar),1,10),substring(cast(SERVERPROPERTY('edition') as nvarchar),1,20)

August 7, 2008 11:43 AM

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement