Re: how do i find sql server license type

From: Rohtash Kapoor (rohtash_nospam_at_sqlmantra.com)
Date: 09/10/04 

Date: Thu, 9 Sep 2004 21:35:15 -0700

FIX: SERVERPROPERTY Returns Incorrect Value for LICENSETYPE
http://support.microsoft.com/?kbid=291332 

---
Rohtash Kapoor
http://www.sqlmantra.com
"SQL apprentice" <mssqlworld@yahoo.com> wrote in message
news:%23RQnO4slEHA.3896@tk2msftngp13.phx.gbl...
> Thanks,
>
> I ran the query...the result is:
>
> Disabled
>
> What does it mean?  How and Why don't I have a license?
>
> "Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
> news:2qcb0hFtose8U1@uni-berlin.de...
> > hi,
> > "SQL apprentice" <mssqlworld@yahoo.com> ha scritto nel messaggio
> > news:ub%23cNuslEHA.1904@TK2MSFTNGP09.phx.gbl...
> > > Hello,
> > >
> > > Is there a way to write a query or using Enterpise Manager to find
what
> > type
> > > of license I have on my SQL Server?
> > >
> > > Thanks in advance.
> > >
> >
> > SELECT SERVERPROPERTY('LicenseType')
> > --
> > Andrea Montanari (Microsoft MVP - SQL Server)
> > http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
> > DbaMgr2k ver 0.9.1  -  DbaMgr ver 0.55.1
> > (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> > interface)
> > --------- remove DMO to reply
> >
>
>