>>>>Hi All,
>>>>
>>>>I developed a copy-protect method with some utitilies from UT and other VFP sources. It looks cpu, hdd serial etc...
>>>>I was use .dbf file and lock one record for each user when developing .dbf based applications for RDP users.
>>>>How can I control active user counts at SQL Server?
>>>
>>>With sufficient permissions (VIEW SERVER STATE specifically), you can work with the sp_who stored procedure..
http://msdn.microsoft.com/en-us/library/ms174313.aspx>>>
>>>make sure you give your application a name in the connection string by the way - makes this much easier to filter!
>>
>>Thank you,
>>
>>That's excellent!.. How can I add my application name at connection string?
>
>See
http://blog.benhall.me.uk/2007/10/sql-connection-application-name.html>
>BTW, you can also check sp_who2 or sp_WhoIsActive stored procedure by Adam Machanic that provides more useful info.
Application name is "Microsoft Visual Foxpro" and I cannot change it with connection string. And there is another problem there are six rows seem just for one application. I just created one handle. Why?