troubleshooting Question

SQL Server Express or Standard?

Avatar of Hypercat (Deb)
Hypercat (Deb)Flag for United States of America asked on
Microsoft SQL Server 2008Microsoft SQL Server
5 Comments1 Solution1068 ViewsLast Modified:
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"?
ASKER CERTIFIED SOLUTION
Kyle Abrahams
Director of Information Technology

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros