How can I see how many SQL CAL's I have on my server. I know how many I am
licenses for, but want to make sure I regulate this on this server. Is there
a license manager I'm not finding?
--
Spencer

Run the following from Query Analyzer to find what the License Type is and
how many Licenses are registered.

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

Select SERVERPROPERTY('LicenseType')

--Number of client licenses registered for this instance of SQL Server, if
in per-seat mode.
--Number of processors licensed for this instance of SQL Server, if in
per-processor mode.
--Returns NULL if the server is none of the above.

Select SERVERPROPERTY('NumLicenses')


Thank you and best regards,

Akshay Mittal, MCSE MCDBA MCSD
Microsoft SQL Server Support Engineer
E-mail: akshaym@microsoft.com


[quoted text, click to view]