June 19, 2011 at 1:04 am
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
June 19, 2011 at 1:33 am
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.
June 19, 2011 at 7:31 am
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.
June 19, 2011 at 7:58 am
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?
June 19, 2011 at 3:30 pm
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.
June 20, 2011 at 9:34 pm
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 🙁
June 20, 2011 at 9:36 pm
Intellisense in SSMS 2008 only works when connected to SQL Server 2008. It is not backward compatible.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply