>>>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.htmlBTW, you can also check sp_who2 or sp_WhoIsActive stored procedure by Adam Machanic that provides more useful info.
If it's not broken, fix it until it is.
My Blog