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.
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.0Which 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 listhttp://support.microsoft.com/kb/321185My 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 |
|
|
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. |
|
|
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-02-24 : 12:29:05
|
quote: Originally posted by visakh16I think...
The screen shot says so. Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-02-24 : 13:11:06
|
You might also try: SELECT @@VERSION |
|
|
|
|
|
|
|