I am trying to confirm the types of SQL licensing that was installed. What can I key on to tell whether it was a processor-based licensing or not?
Hi,
For SQL 2000 , execute the below command in Query Analyzer:-
select serverproperty('LicenseType')
For older versions check:-
Check the Control panel -- Admin tools -- Licensing.
Thanks
Hari
MCDBA
"Jason Oliver" <joliver@.chw.org> wrote in message
news:84D1964A-D33C-4553-988A-31AF2FFB785C@.microsoft.com...
> I am trying to confirm the types of SQL licensing that was installed.
What can I key on to tell whether it was a processor-based licensing or not?
|||Hi -
Use :-
use master
go
Select Serverproperty('LicenseType')
go
Thanks
-Surajit
"Jason Oliver" <joliver@.chw.org> wrote in message
news:84D1964A-D33C-4553-988A-31AF2FFB785C@.microsoft.com...
> I am trying to confirm the types of SQL licensing that was installed.
What can I key on to tell whether it was a processor-based licensing or not?
|||Or go to control panel -> SQL Server Licensing Setup
Eric Li
SQL DBA
MCDBA
Jason Oliver wrote:
> I am trying to confirm the types of SQL licensing that was installed. What can I key on to tell whether it was a processor-based licensing or not?
No comments:
Post a Comment