July 8, 2004 at 9:53 am
I know in SQL 2000 I can issue "select serverproperty('numlicenses')" to determine the # of CALs. What is the comparable command in SQL 7.0? I don't have an old copy of BOL so I'm kind of stumped. In addition, how can a server return NULL as the number of CALs? Shouldn't there be some value? TIA
Terry
July 8, 2004 at 10:19 am
Depending on the set-up of the SQL server i.e. either per Server, Process, user the CAL may show as NULL. Also, the different versions of SQL 2K may show as NULL,
My SQL 2K install on my PC shows NULL.
Thanks,
AJ
Good Hunting!
AJ Ahrens
webmaster@kritter.net
July 9, 2004 at 11:10 am
When I run "select serverproperty('licensetype')" I get "PER_PROCESSOR".
When I run "select serverproperty('numlicenses')" I get 4.
BOL says "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."
You could go to Control Panel / Licensing to see what is listed there.
Linda
July 9, 2004 at 11:34 am
Linda,
When I do select serverproperty('licensetype'), it returns disabled. When I do select serverproperty('numlicenses') it returns NULL. What does that mean? It's definitely an active SQL server.
Terry
July 9, 2004 at 12:23 pm
The License Logging Service on your server probably is not running. (I was able to create the same errors on our test box by shutting if off.) Start the service if it isn't running and try your queries again.
Linda
July 9, 2004 at 12:33 pm
The service was on so I stopped/restarted it and get the same results. Any additional thoughts?
Terry
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply