469,081 Members | 1,817 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

SQL Server Licensing

How does one find out what type of licensing is employed on a SQL
Server Box. i.e is it Per Process or Per CAL?

Martyn

Jul 23 '05 #1
6 1237
SELECT SERVERPROPERTY('LicenseType')

--
David Portas
SQL Server MVP
--

Jul 23 '05 #2
David, do you know what it means if the query returns "DISABLED" ?

-- Mark D Powell --

Jul 23 '05 #3
Either you've got Developer Edition (Check SELECT
SERVERPROPERTY('Edition') to find out) or it's been installed from the
MSDN disk set. Both are for non-production use and so don't implement
the licence model setting.

--
David Portas
SQL Server MVP
--

Jul 23 '05 #4
Stu
It means that Bill Gates will be knocking on your door at any minute :)
(Thank you, I'll be here all week. Try the veal.)
From the Books OnLine:


LicenseType Mode of this instance of SQL Server.
PER_SEAT = Per-seat mode
PER_PROCESSOR = Per-processor mode
DISABLED = Licensing is disabled.

It may be because the applet is disabled in Windows Server 2003 by
default: http://support.microsoft.com/default...b;en-us;824196

Jul 23 '05 #5
The response for the query was "Standard Edition".

Thank you for the response.

-- Mark D Powell --

Jul 23 '05 #6
Stu, thank you for the link. It would seem that disabled is the
expected value.

-- Mark D Powell --

Jul 23 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by John Dalberg | last post: by
2 posts views Thread by Marc | last post: by
14 posts views Thread by Guillermo_Lopez | last post: by
1 post views Thread by =?Utf-8?B?QW50amU=?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.