Friday, March 9, 2012

how to find out licenses installed

I have a SQL server and would like to konw what kind of licensing it is
using , how can i find out? Thanks.
Hi,
FOR SQL 2000, Execute the below script:-
select serverproperty('LicenseType') as Licence_type
go
select serverproperty('NumLicenses') as Num_of_licences
For SQL 7 and Older versions:-
1. Go to COntrol Panel..
2. Double click above the licences and select the SQL Server License.
3. This will show you the type of license and count.
Thanks
Hari
MCDBA
"john" <john@.aicinc.com> wrote in message
news:uNjGb$KYEHA.384@.TK2MSFTNGP10.phx.gbl...
> I have a SQL server and would like to konw what kind of licensing it is
> using , how can i find out? Thanks.
>

No comments:

Post a Comment