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?
 
Ramesh Babu VavillaCommented:
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 LanhamCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Anthony PerkinsCommented:
As indicated previously you have SQL Server 2008-R2 Express Edition installed and you are using SSMS version 2008 (not 2008-R2).
0
 
Anthony PerkinsCommented:
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.