Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

SELECT @@version

or, as per http://support.microsoft.com/kb/321185:

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

1 Answer 1

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

 
discard

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.