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
andrew
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
|||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