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 |
|
Clairew
Starting Member
2 Posts |
 Posted - 2011-11-18 : 06:53:58
|
| Hi,I'm quite new to administering SQL and have very little knowledge about it. Basically I'm trying to find the version we have installed. I thought it was SQL 2008 Express however when I open the Management Studio and go to "About" it says "Microsoft SQL Server 2008 R2" and the version is 10.50.1600.1. However, when I run a query on a database it brings back the same Product Version but with the Edition "Express Edition with Advanced Services" and ProductLevel of "RTM". Can someone shed some light for me? Are we running the full version or just the express?Thanks in advanceClaire |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-18 : 07:11:15
|
| You have SQL Server 2008 R2 Express Edition with no service packs installed--Gail ShawSQL Server MVP |
 |
|
|
Clairew
Starting Member
2 Posts |
Posted - 2011-11-18 : 07:17:16
|
| Thanks Gail for the fast response!Just to make sure is there any reason why the splash screen when we open the Management Console doesn't specify that it's Express? I have SQL 2005 Express installed on a different machine and it displays this on splash screen? I know that's probably a silly question but I'm just trying to make sure! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-18 : 08:33:17
|
| Could be it's SSMS from a full version of SQL. There's little difference, so it's not a problem. The tool version doesn't necessarily match the DB version. What's important is the DB engine version. SELECT @@version will get that in its entirety.--Gail ShawSQL Server MVP |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2011-11-22 : 18:34:26
|
| Claire,There are a few sites that keep track of the different release numbers and what they mean. This is not exactly what you asked about but its a useful point of refernce (Feel free to disregard completely):http://www.sqlteam.com/article/sql-server-versionshttp://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx=======================================Faced with the choice between changing one's mind and proving that there is no need to do so, almost everyone gets busy on the proof. -John Kenneth Galbraith |
|
|
|
|
|
|
SQL Version