Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to determine your version of Sql Server 2008

Author  Topic 

Halle
Starting Member

9 Posts

Posted - 2014-02-22 : 14:25:40
Hello,

I am trying to determine the version of Sql Server that I have on my computer. When I open the Management Studio, the flash screen gives me "Sql Server 2008 R2. When I look to the left under object explorer it says;

MYNAME-\PCSQLEXPRESS(SQLSERVER 9.0.5000 - MYNAME-PC\MYNAME)

When I go to help/about and the dialog box says;

Microsoft SQL Server Management Studio 10.50.4000.0

Which numbers am I going by to determine my version of Sql Server 2008
9.0.5000 under object explorer or 10.50.4000.0 in the help/about dialog box.

According to this website(below) 9.0.5000 version is Sql Server 2005. I am running Sql Server 2008 I am trying to determine weather my version is compatible with someone running Sql Server 2008 where under their object explorer the number is 10.0.2531.

Sql Server versions list
http://support.microsoft.com/kb/321185


My help/about dialog box

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-02-22 : 14:38:08
Check out SERVERPROPERTY or SERVERPROPERTYEX function.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

Halle
Starting Member

9 Posts

Posted - 2014-02-22 : 15:12:31
quote:
Originally posted by SwePeso

Check out SERVERPROPERTY or SERVERPROPERTYEX function.



Thanks. I did just that and it showed me 9.0.5000. This according to the versions list website is Sql Server 2005. Now I am confused when I am running Sql Server 2008 R2! I am going to Google how to upgrade my product to 10.5.4000 without uninstalling and reinstalling the whole thing new.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-02-23 : 06:03:49
quote:
Originally posted by Halle

quote:
Originally posted by SwePeso

Check out SERVERPROPERTY or SERVERPROPERTYEX function.



Thanks. I did just that and it showed me 9.0.5000. This according to the versions list website is Sql Server 2005. Now I am confused when I am running Sql Server 2008 R2! I am going to Google how to upgrade my product to 10.5.4000 without uninstalling and reinstalling the whole thing new.



I think it may be that client tools you use (SQL management studio etc) are of version 2008 R2 whereas database you're actually connecting to maybe of version 2005.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-02-24 : 12:29:05
quote:
Originally posted by visakh16
I think...
The screen shot says so.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2014-02-24 : 13:11:06
You might also try: SELECT @@VERSION
Go to Top of Page
   

- Advertisement -