Links
TADOSqlManagerQuery Component References
TADOSqlManagerQuery::GetConnections Method
__fastcall bool GetConnections(TTntStringList* Connections, bool UserOnly);

Provides information about current Microsoft® SQL Server™ users and processes. 

Connections: Connection list 

UserOnly: List only user connections 

After return, Connections will contain XML data in the following format:

  • <Connections>
    • <Connection>
      • <ProcessID></ProcessID>
      • <ContextID></ContextID>
      • <Status></Status>
      • <Login></Login>
      • <Hostname></Hostname>
      • <BlockingProcess></BlockingProcess>
      • <Database></Database>
      • <Command></Command>
    • </Connection>
  • </Connections>
Copyright (c) 2006. All rights reserved.
What do you think about this topic? Send feedback!