Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Detect active users at SQL Server
Message
 
À
13/11/2011 17:08:30
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01528779
Message ID:
01528832
Vues:
111
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!
____________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform