check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:

> Hi, May I know how to check what is my current sql licence installed? I'v
e
> learnt that in control panel, there is a SQL Licence setup icon which I ca
n
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
[vbcol=seagreen]
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
>|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
David Gugick
Imceda Software
www.imceda.com

check sql licence

Hi, May I know how to check what is my current sql licence installed? I've
learnt that in control panel, there is a SQL Licence setup icon which I can
check. But some of my MSSQL server don't have this icon. Can you help?
Thanks
andrewTry to run this:
select serverproperty('LicenseType')
, serverproperty('NumLicenses')
"andrew" wrote:
> Hi, May I know how to check what is my current sql licence installed? I've
> learnt that in control panel, there is a SQL Licence setup icon which I can
> check. But some of my MSSQL server don't have this icon. Can you help?
> Thanks
> andrew|||Hi,
The result is:
disabled, null
May I know how can I change the values?
"Andre Vigneau" wrote:
> Try to run this:
> select serverproperty('LicenseType')
> , serverproperty('NumLicenses')
>
> "andrew" wrote:
> > Hi, May I know how to check what is my current sql licence installed? I've
> > learnt that in control panel, there is a SQL Licence setup icon which I can
> > check. But some of my MSSQL server don't have this icon. Can you help?
> >
> > Thanks
> > andrew|||andrew wrote:
> Hi,
> The result is:
> disabled, null
> May I know how can I change the values?
>
LicenceType is not "implemented" in a reliable way. There was post about
this same problem a couple weeks ago. Trying giving the ng a search on
Google.
--
David Gugick
Imceda Software
www.imceda.com