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?
Showing posts with label confirm. Show all posts
Showing posts with label confirm. Show all posts
Monday, March 19, 2012
How can you tell which license was installed
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?
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?
How can you tell which license was installed
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?
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?
Subscribe to:
Posts (Atom)