By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

Finding SQL Licensing information?

P: 30
hi all,
I want to retrive the licensing information such as Licensing count, which
licensing is currently in use, whats its type (per processer or per user),
licensing code etc. From where i can retrive the information? I want to do it
for Sql Server 2005 and 2000. I read the blog "Tracking License Information
in SQL 2005" on
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
but it doesnt help me at all.
Mar 13 '08 #1
Share this Question
Share on Google+
1 Reply


deepuv04
Expert 100+
P: 227
hi all,
I want to retrive the licensing information such as Licensing count, which
licensing is currently in use, whats its type (per processer or per user),
licensing code etc. From where i can retrive the information? I want to do it
for Sql Server 2005 and 2000. I read the blog "Tracking License Information
in SQL 2005" on
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
but it doesnt help me at all.
SELECT SERVERPROPERTY('LicenseType')

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

SELECT SERVERPROPERTY('NumLicenses')

NumLicenses - 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.
Mar 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.