how to count used lincenses 
Author Message
 how to count used lincenses

Freddy,

SELECT   SERVERPROPERTY('NumLicenses')

But theres a bug in that if you are not on SP2...refer
http://www.***.com/ ;EN-US;q291332&GSSNB=1

Dinesh.


Quote:
> Hello, who can tell me how to check the number of used
> client connections at a certain moment on an sql2000
> server. I configured that server per seat for 20 clients
> and I want to know if that is enough. Thanks for any help



Tue, 20 Jul 2004 23:46:23 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. using SELECT COUNT(*) to count distinct records

2. Syntax error COUNT() : Using COUNT() with char field

3. Using SQL to count as if using an array

4. Getting count and result set using dynasets and stored procedures

5. Using aggregate function count()

6. Using Select Count in ASP

7. Puzzler: Distinct counts on aggregate data using cube

8. #ERR in Analysis Browser when using Distinct Count measure

9. Faster count using sysindexes in a relational model

10. Need help with multiple SELECT using multiple COUNTs

11. Keeping duplicates using Count and Max with RIGHT OUTER JOIN

12. Counting rows using a system stored procedure


 
Powered by phpBB® Forum Software