MS SQL Server - Licensing Question...

Author

Licensing Question...

Phil T.

2005-04-06, 8:01 pm

Just took over SQL server, is there a way to determin the current licensing
type and level details?

TIA,
Phil

Peter Nolan

2005-04-06, 8:01 pm

Have a look at http://www.microsoft.com/sql/howtobuy/faq.asp

"Phil T." wrote:

> Just took over SQL server, is there a way to determin the current licensing
> type and level details?
>
> TIA,
> Phil

Cristian Lefter

2005-04-06, 8:01 pm

code:
SELECT    CONVERT(nvarchar(128
),  SERVERPROPERTY('Lice
nseType'))

Cristian Lefter, SQL Server MVP

"Phil T." <PhilT@discussions.microsoft.com> wrote in message
news:9694A323-0D94-45C5-B937- CE4484DE57F7@microso
ft.com...
> Just took over SQL server, is there a way to determin the current
> licensing
> type and level details?
>
> TIA,
> Phil

Jack

2005-04-06, 8:01 pm

select serverproperty('lice
nsetype')

select serverproperty('numl
icenses')

"Phil T." wrote:

> Just took over SQL server, is there a way to determin the current licensing
> type and level details?
>
> TIA,
> Phil

Phil T.

2005-04-06, 8:01 pm

I appreciate the responses however; let me explain my question further. The
SQL 2000 server in question "is" licensed. I am not a programmer but, if you
could elaborate on this code snippet I could probably fumble my way through
it;

Is it a VBS script, ASP? Can I just create it out of a txt file changing
the extension and run it on the SQL server?

TAIA,
Phil

"Cristian Lefter" wrote:

>

code:
> SELECT    CONVERT(nvarchar(128
),  SERVERPROPERTY('Lice
nseType'))
>

>
> Cristian Lefter, SQL Server MVP
>
> "Phil T." <PhilT@discussions.microsoft.com> wrote in message
> news:9694A323-0D94-45C5-B937- CE4484DE57F7@microso
ft.com...
>
>
>

Peter Nolan

2005-04-06, 8:01 pm

Apologies for not reading your first response closely enough.

Christian (All Hail the MVP's) code is T-SQL that you will need to run from
either Enterprise Manager or Query Analysier. Personally my choice would be
Query Analyser.

If you open up Enterprise manage and select 'Tools' , 'SQL Query Analyser',
paste

SELECT CONVERT(nvarchar(128
), SERVERPROPERTY('Lice
nseType'))

into the top window then press F5 another window should appear below it with
the results.

"Phil T." wrote:
[color=darkred]
> I appreciate the responses however; let me explain my question further. The
> SQL 2000 server in question "is" licensed. I am not a programmer but, if you
> could elaborate on this code snippet I could probably fumble my way through
> it;
>
> Is it a VBS script, ASP? Can I just create it out of a txt file changing
> the extension and run it on the SQL server?
>
> TAIA,
> Phil
>
>
> "Cristian Lefter" wrote:
>

ykchakri

2005-04-06, 8:01 pm

You can also find it graphically by going to Control panel on the server and
clicking on 'SQL Server 2000 Licensing setup'.
"Phil T." <PhilT@discussions.microsoft.com> wrote in message
news:9694A323-0D94-45C5-B937- CE4484DE57F7@microso
ft.com...
> Just took over SQL server, is there a way to determin the current
> licensing
> type and level details?
>
> TIA,
> Phil

Sponsored Links