Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SQL SERVER 2005 shows the version as SQL SERVER 2000 when queried

Discussion SQL SERVER 2005 shows the version as SQL SERVER 2000 when queried

  • Wednesday, August 08, 2012 8:22 AM
     
     
    Sign In to Vote
    0

    Hi Team,

    I've installed "SQLServer2005_SSMSEE.msi" on my machine and when i queried "select @@version", the output is:

    "Microsoft SQL Server  2000 - 8.00.194 (Intel X86)"   Aug  6 2000 00:57:48   Copyright (c) 1988-2000 Microsoft Corporation  Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 3)

    Any idea why it is showing the version as 2000 wrongly. And its not allowing me to restore the 2005 .bak DB Backup on my machine.

    Thanks In Advance

    Sridhar D Naik

     

All Replies

  • Wednesday, August 08, 2012 8:59 AM
     
     
    Sign In to Vote
    0
    You have installed only client tools (SS2005) but connect still to the SQL Server 2000 server, am I right?

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/

     
  • Wednesday, August 08, 2012 9:36 AM
     
     
    Sign In to Vote
    0

    Hi Uri,

    I have no instance of SQL Server 2000 on my Machine.

    Also, to let you know, i've installed SQL Server 2008 on my Machine and it shows correct version when queried " Select @@version" against it.

    So i am willing to have both 2005 and 2008 instances on my Machine. But 2005 isn't showing the correct version.

    Thank You

    Sridhar D Naik