Is there a best practice in determining whether MSDE installed on a
workstation or if SQL Express is installed?  The SQL Express installs
are all with the default named instance of .\SQLExpress, but it's not
otherwise generally known as to which version is present.

Specifically, a (DOS) bat file is periodically launched to run a sql
script (via osql.exe).  Somehow, the bat file needs to handle the
difference between the MSDE default instance and the SQL Express named
instance.

I thought of using the installed paths to make a decision in the bat
file, for instance:

IF EXIST "C:\Program Files\Microsoft SQL Server\90" GOTO :Express

osql.exe -S (local) -E -i myfile.sql -n
GOTO :EOF

osql.exe -S .\SQLExpress -E -i myfile.sql -n

('Course the second osql.exe reference above could be to sqlcmd.exe
instead).

Thanks!