THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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:

 

http://sqlserverbuilds.blogspot.com/

 

http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html

 

Be sure to add them to your Favorites! 

 

Cheers,

 

-Kev

Published Tuesday, August 05, 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

Comments

 

Norman said:

August 5, 2008 2:20 PM
 

KKline said:

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

-Kev

August 5, 2008 2:33 PM
 

Remus said:

There is also an MS KB article at http://support.microsoft.com/kb/321185

August 5, 2008 2:53 PM
 

AaronBertrand said:

I had been maintaining a build list for SQL Server 2005 as well; however, the aspfaq.com 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.

http://www.aspfaq.com/sql2005/show.asp?id=20

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

(required) 
(required) 
Submit

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, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement