Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Determining If You Are Running MSDE or SQL Server 7.0
Article ID: 199395 - View products that this article applies to.
This article was previously published under Q199395
Moderate: Requires basic macro, coding, and interoperability skills.
To see whether you are running Microsoft Data Engine (MSDE) or Microsoft SQL Server 7.0, you can check the Sqlstp.log file located in your Windows or Winnt folder.
The setup log file, Sqlstp.log, is created during setup and contains detailed information about your Microsoft Data Engine or Microsoft SQL Server 7.0 configuration. To open this file, follow these steps:
In the first several lines, the entry "SQL Server ProductType:" tells you what version you are running. The Microsoft Data Engine will say "Office," whereas Microsoft SQL Server 7.0 will say "Standard" for this entry.
Example Entries for Microsoft Data Engine16:20:05 Begin Setup
16:20:06 System: Windows 98
16:20:06 Mapping: 0x1
16:20:06 SQL Server ProductType: Office
16:20:07 Begin Action: CheckRequirements
Example Entries for Microsoft SQL Server 7.009:35:26 Begin Setup
09:35:27 Begin Action: CheckRequirements
09:35:27 System: Windows NT Server
09:35:27 Version: 4.0.1381
09:35:29 SQL Server ProductType: Standard