This article was previously published under Q199395
This article has been archived. It is offered "as is" and will no longer be updated.
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:
On the File menu, click Open.
In the Open dialog box, browse to your Windows or Winnt folder.
In the Files of type box, select All Files (*.*.)
In the File name box, type Sqlstp.log.
If the Sqlstp.log file is very large, you may need to open it in WordPad or another text editor.
In the first several lines, the entry "SQL Server ProductType:" tellsyou 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 Engine
16:20:05 Begin Setup 16:20:05 7.00.549 16:20:05 Mode=Normal 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.0
09:35:26 Begin Setup 09:35:26 7.00.517 09:35:26 Mode=Normal 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