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

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@xxxxxxxxx> wrote in message
news:1168988743.254141.202070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • RE: Server cant be seen from the network
    ... Microsoft CSS Online Newsgroup Support ... I discovered that if I turned the SQL server ... NAT issues caused with the installation of the "full" SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
  • Re: ISA 2004 - disable MSDE
    ... when installing the version of MSDE contained in the MS SQL ... server CD, MSDE is set to operate in Windows Authentication mode only. ... ISA, DO NOT UNINSTALL IT!, just the other MSDE installation). ...
    (microsoft.public.isaserver)
  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Help Please with a step by step keystroke by keystroke(or Mouse) illustration on how to setup a stan
    ... the most typical for the average developer wanting to push .Net SQL driven ... did it would involve a domain server, ... client network utility force protocol encryption is NOT checked) ... Please give a complete account of the standalone CA installation as this ...
    (microsoft.public.sqlserver.security)
Loading