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.
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.
Tom wrote:[vbcol=seagreen]
> 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.
>
> "Flash08" <stuart.karp@.gmail.com> wrote in message
> news:1168982219.854052.130750@.q2g2000cwa.googlegro ups.com...
|||SERVERPROPERTY is probably the safest thing to use. The possible return
values are listed here:
http://msdn2.microsoft.com/en-us/library/ms174396.aspx
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.microsoft.com/info/cpyright.htm
"Flash08" <stuart.karp@.gmail.com> wrote in message
news:1168988743.254141.202070@.m58g2000cwm.googlegr oups.com...
> 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.
>
> Tom wrote:
>
sql