SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to determine your version of Sql Server 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Halle
Starting Member

9 Posts

Posted - 02/22/2014 :  14:25:40  Show Profile  Reply with Quote
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

Sweden
30282 Posts

Posted - 02/22/2014 :  14:38:08  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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 - 02/22/2014 :  15:12:31  Show Profile  Reply with Quote
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.

Edited by - Halle on 02/22/2014 15:34:41
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 02/23/2014 :  06:03:49  Show Profile  Reply with Quote
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

Sweden
30282 Posts

Posted - 02/24/2014 :  12:29:05  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

4614 Posts

Posted - 02/24/2014 :  13:11:06  Show Profile  Reply with Quote
You might also try: SELECT @@VERSION
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000