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

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:
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@xxxxxxxxx> wrote in message
news:1168982219.854052.130750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Missing DLL during re-installation
    ... The installation appeared to complete successfully and I ... SQL Server Setup failed to execute a command for server configuration. ... Refer to the server error logs and Setup ...
    (microsoft.public.sqlserver.setup)
  • Re: Solution to do Accent Insensitive Full Text Search with SQL Server 2000
    ... Also note that SQL 2005 does support accent insensitive searching. ... Looking for a SQL Server replication book? ... Installing an accent insensitive version of Microsoft Search ... This is the installation program we will use to ...
    (microsoft.public.sqlserver.fulltext)
  • =?iso-8859-1?Q?Re:_Installation_von_SQL-Server_Expres_schl=F6gt_fehl?=
    ... dass bei der Installation von Visual Studio eine SQL Server Express Instance installiert wird?! ... Falls du vor der Installation von Inventor schon VS installiert hattest, musste die SQL Express Installation fehlschalgen! ...
    (microsoft.public.de.sqlserver)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... the first instance on the cluster. ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • 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)
Loading