SQL Versions

SQL Versions

I am kind of confused when I try to find the version of SQL server

I believe I need to check the properties of the instances instead of the "About" page of the of the Management Studio.

in the screenshots below I wonder if I am using sQL Server 2008 or SQL Express.

Any help will be very much appreciated.

Thanks


instanceAbout
jskfanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ramesh Babu VavillaConnect With a Mentor Commented:
you are having SQL Server 2008 R2 installed on you server

buy you have sql server 2008 management studio installed in it

sql server management studio is simply a GUI tool used to connect the sqL Server and organise it
0
 
Ryan LanhamConnect With a Mentor Commented:
Your running Express. The topline of the first screen shot indicates that.

10.50.2500.0 Tells us you are running 2008 R2 SP1.

So you have SQL Express 2008 R2 SP1 installed.

http://www.microsoft.com/en-us/download/details.aspx?id=26729
0
 
jskfanAuthor Commented:
so to determine the edition of SQL server I need to go to the properties of the SQL instance
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Anthony PerkinsConnect With a Mentor Commented:
As indicated previously you have SQL Server 2008-R2 Express Edition installed and you are using SSMS version 2008 (not 2008-R2).
0
 
Anthony PerkinsConnect With a Mentor Commented:
so to determine the edition of SQL server I need to go to the properties of the SQL instance
You can.  It is just easier to query it from SSMS.
0
 
jskfanAuthor Commented:
the first screenshot I pasted was after I opened up SSMS the right-clicked on the instance name then properties….That's where It shows "Microsoft SQL Server Express Edition (64bits)"
0
 
jskfanAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.