Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect active users at SQL Server
Message
 
To
13/11/2011 17:08:30
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01528779
Message ID:
01528832
Views:
112
This message has been marked as the solution to the initial question of the thread.
>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!
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform