How to determine MSDE or SQL 2005 Express vs. SQL 2000 or SQL 2005

Hi all,

I need to determine if MSDE or SQL 2005 Express is installed versus the
full version of SQL 2000 or SQL 2005. I only want my installation to
run if the full versions of SQL is installed. Where can I find this
information? Is it in the registry, can I do a SQL query that tells me
this info?
Basically I need a way of distinguishing between the free and full
versions. Any help would greatly be appreciated. Thanks in advance.

.

Relevant Pages

  • SQL Server is terminating due to stop request
    ... Installation of MSDE SP3A fails on XP SP2 with these messages in the log:- ... SQL Server is terminating due to 'stop' request from Service Control Manager. ... SP2 machine bought to run our software by a teacher with limited IT skills. ...
    (microsoft.public.sqlserver.setup)
  • Re: Is it possible that OLEDB connection is not available on a PC?
    ... Hmm, unlikely as it seems given your OS, corrupted MDAC installation? ... If you still have no joy, I suggest you post to a SQL Server group. ... I believe there MSDE has been updated quite ...
    (microsoft.public.inetserver.asp.db)
  • Re: error 1304 - MSDE
    ... MSDE Installation Fails on Systems That Have SQL Server 2000 ...
    (microsoft.public.de.sqlserver)
  • NTWDBLIB.DLL
    ... I recently installed MSDE 2000 Release A on my computer ... as SQL Server and got it running. ... However, since I am using cuteSQL as an SQL client, ... during MSDE Server installation. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)