19811cdb   
   From: news@invalid.invalid   
      
   > Users access by an application level, and the application level use   
   > always the same user....   
   > So I suppose I have to look at the connection by host.   
   > 1) Is there a view to do this?   
   > 2) It seems just an "empirical" solution. There is not an "official"   
   > repository of the CALs?   
      
   I think there is no official solution for tracking CALs.   
      
   If you can say "one host, one user" then you can use the hosts to   
   identify different users.   
      
   Look at the following path - Database(master) - Views - System Views (?)   
      
   SELECT * FROM [sys].[sysprocesses]   
   SELECT * FROM [sys].[dm_exec_connections]   
      
   Use the online help to understand the informations the views give you.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)