We help IT Professionals succeed at work.
Get Started

SQL Server Express or Standard?

1,067 Views
Last Modified: 2017-04-17
I've taken over administration of a network from another vendor.  One of the many puzzling items I'm trying to figure out is a (somewhat) misbehaving SQL server.  The server has 2 databases, one for Lexis-Nexis TimeMatters (law firm doc management program) and one for SoftPro (other law firm software).  They're having some weird issues with TimeMatters that I'm trying to solve. In the process of trying to identify potential causes of problems, I'm trying to identify exactly what version of SQL they're running.  Here's what I'm seeing that's confusing:

1.  The SQL server instance indicates that it is running SQL Server Express - that is, both the Services panel and the Management Studio show "SQLExpress" as the instance name.
2.  However, the server build number is 10.50.2500 which corresponds to SQL Server 2008 R2 SP1. Does SQL Server Express use the same build number?  My searches aren't coming up with a separate document for SQL Express build numbers.
3.  There is a database on this server which is 41GB in size.  How can this database be running if the SQL version is in fact Express?

So, I'm wondering is it possible to upgrade a SQL instance from Express to Standard and still have an instance name of "SQLExpress"?
Comment
Watch Question
Director of Information Technology
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE