surprise with the version in 2008

  • manoj2001

    SSCrazy

    Points: 2175

    recently i have installed sql server 2008 client (eval - 180 days) on one of my colleague desktop. but when i had a look on @@version i was surprised..it was showing ver 9.0 ....instead of 10.0.

    To clear my doubt i have checked in SQL Query analyzer..help about iteam and pover there it was showing proper version....2008...i mean is it possible or is there any bug?

    experts...MS authorities waiting for your comments...inputs..thanks Manoj

  • Lynn Pettis

    SSC Guru

    Points: 442344

    If all you installed was the client (SSMS) then it is possible that it is connecting to a SQL Server 2005 server. You can use SQL Server 2008 client tools to connect to and manage SQL Server 2005.

  • manoj2001

    SSCrazy

    Points: 2175

    Thanks for reply lynn.

    We had installed SQL Server 2008 Client only and it is displaying 2010 only in Help -> About menu but not in SELECT @@version.

  • John Barnett

    SSCommitted

    Points: 1976

    Are you sure you were connecting to the same database server? Query Analyser was last provided with SQL 2000 and should be avoided on newer versions (it may not allow connections via it to newer versions).

    does

    SELECT @@servername

    give the same results from each client?

  • Lynn Pettis

    SSC Guru

    Points: 442344

    The help about is going to tell the version of the client tool while the @@version is going to tell you the version of the database server to which you are connected. They are two different things.

  • manoj2001

    SSCrazy

    Points: 2175

    Thanks again Lynn.

    But it should come with intellisense right? i mean it is one of the feature of 2008 right?

    but it is also not there in the installed version....something is wrong either way 🙁

  • Lynn Pettis

    SSC Guru

    Points: 442344

    Intellisense in SSMS 2008 only works when connected to SQL Server 2008. It is not backward compatible.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply