Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We've got a server with SQL Server 2008 installed, but if we run:

SELECT @@version

or, as per

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

the version number is reported as 8.0.2055 - I'm pretty sure that the server used to have SQL Server 2000 installed but was upgraded about a year ago.

Has anyone come across anything like this before? If so, how do you get SQL Server 2008 to report the correct version number?

share|improve this question
up vote 2 down vote accepted

Are you certain you're connecting to the right instance of SQL Server? It sounds like your server has two instances (one under SQL2000) running.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.