Is it MSDE or SQLServer

Hi All
How can i see if the database running is a SQL server or a MSDE?
regards,
Erik Visser
SELECT @.@.VERSION
It will return something like:
MSDE:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT
5.0 (Build 2195: Service Pack 4)
SQL SERVER:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
Cheers,
James Goodman
"Erik Visser" <evisser@.hotmail.com> wrote in message
news:c6t01m$fnglv$1@.ID-206424.news.uni-berlin.de...
> Hi All
> How can i see if the database running is a SQL server or a MSDE?
> regards,
> Erik Visser
>
|||> SELECT @.@.VERSION
Yep, this works.
Thanks!
Erik
|||In addition to what James wrote, the SERVERPROPERTY(Edition) function would
probably give you a more direct (and system readable) option.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Erik Visser" <evisser@.hotmail.com> wrote in message
news:c6t7ka$fvc1o$1@.ID-206424.news.uni-berlin.de...
> Yep, this works.
> Thanks!
> Erik
>
|||On a similar topic, is there a reliable way to tell if the "full" SQL Server
is simply installed (not MSDE), perhaps through registry entries? I'd like
to determine in my installer whether or not the user has the full SQL Server
installed already and if they do, use that instead of installing MSDE.
"Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> In addition to what James wrote, the SERVERPROPERTY(Edition) function
would
> probably give you a more direct (and system readable) option.
> HTH,
> --
> Greg Low (MVP)
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
>
> "Erik Visser" <evisser@.hotmail.com> wrote in message
> news:c6t7ka$fvc1o$1@.ID-206424.news.uni-berlin.de...
>
|||I installed MSDE 2000A in a computer but that's not what I get when I do
that:
here is what I get:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
(1 row(s) affected)
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> SELECT @.@.VERSION
> It will return something like:
> MSDE:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
>
> SQL SERVER:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
> --
> Cheers,
> James Goodman
> "Erik Visser" <evisser@.hotmail.com> wrote in message
> news:c6t01m$fnglv$1@.ID-206424.news.uni-berlin.de...
>
|||Hi JJ,
You'll find pretty much everything you need with the SERVERPROPERTY
function. With it's different parameters, it can tell you everything from
service pack levels to collations to clustering details to licensing styles,
etc.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"JJ" <jjjj@.nospam.com> wrote in message
news:OCf8aOrLEHA.340@.TK2MSFTNGP11.phx.gbl...
> On a similar topic, is there a reliable way to tell if the "full" SQL
Server
> is simply installed (not MSDE), perhaps through registry entries? I'd
like
> to determine in my installer whether or not the user has the full SQL
Server
> installed already and if they do, use that instead of installing MSDE.
>
> "Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
> news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> would
>
|||Execute into text and copy the whole result here.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Francisco" <nomail@.baseball.net> wrote in message news:ubxIggrLEHA.2244@.tk2msftngp13.phx.gbl...
> I installed MSDE 2000A in a computer but that's not what I get when I do
> that:
> here is what I get:
>
> ----
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> (1 row(s) affected)
>
>
> "James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
> news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> NT
>
|||Here's the registry root for SQL Server for a default instance (and earlier versions)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
And below is for the named instances:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
Above should give you a starting point.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"JJ" <jjjj@.nospam.com> wrote in message news:OCf8aOrLEHA.340@.TK2MSFTNGP11.phx.gbl...
> On a similar topic, is there a reliable way to tell if the "full" SQL Server
> is simply installed (not MSDE), perhaps through registry entries? I'd like
> to determine in my installer whether or not the user has the full SQL Server
> installed already and if they do, use that instead of installing MSDE.
>
> "Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
> news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> would
>
|||Using Query Analyzer? And results in text? Or something else?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Francisco" <nomail@.baseball.net> wrote in message
news:ubxIggrLEHA.2244@.tk2msftngp13.phx.gbl...
>I installed MSDE 2000A in a computer but that's not what I get when I do
> that:
> here is what I get:
>
> ----
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> (1 row(s) affected)
>
>
> "James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
> news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> NT
>