Developer Forum

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.

If you use the SQL Server Mgt Studio, you right click on the registered
server and one of the general properties is the 'Product' name, which states
that it is SQL Server Express or SQL Server Developer etc.

Hi,

Sorry, I should've been more clear. This is for an installation
package, so I want the install package to check the version of SQL on a
user's machine. It would need to query the database or check a
registry key, or file version, etc.
If I did select @@version would this say it's MSDE ot SQL 2005 Express?

I just found something that I'm not sure will work or not:
SELECT SERVERPROPERTY ('edition')

It looks like it will return either
Personal Edition
or
Standard Edition

depending on what you have (I assume Enterprise Edition as well).

Is this enough to determine whether or not it is MSDE (and SQL 2005
Express) or a full install?
Thanks.

SERVERPROPERTY is probably the safest thing to use. The possible return
values are listed here:
http://www.yqcomputer.com/


--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.yqcomputer.com/