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"?