MSDE or WMSDE ?

I faced the following problem, yesterday : verifying if I was  running (SQL Server) MSDE or WMSDE;

Solution : check the follwing directory :

<Installation Drive>:\Program Files\Microsoft SQL Server\MSSQL$<instance name>\LOG

 

open the log file with notepad and if you get this :

Microsoft SQL Server 2000 – 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop
Engine on Windows NT 5.0 (Build 2195: Service Pack 3)  ==> you’re using MSDE

Microsoft SQL Server 2000 – 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop
Engine (Windows) on Windows NT 5.0 (Build 2195: Service Pack 3) ==>you’re using WMSDE

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s