User Inquiry is used to view a list of of users currently connected to the database server and running Vans.
This inquiry can also be used to disconnect users. GREAT CARE should be taken when using this feature. A user should only be disconnected if they are really not doing anything, or their workstation dropped connection, but the database server didn't close the connection properly.
Note: If the user is really connected and active, they will not be terminated, but will likely get an error when they try and do their next transaction/process that will force them to close Vans and restart it.
Screens
Name |
Description |
Displays all the current users on the sytem |
User Inquiry
Field Descriptions
Name |
Description |
User License |
Number of users licensed for the Vans product. |
Active Users |
Number of active users (total of rows in the users grid). |
All Connections |
By default, only users of Vans will be shown. Select this option if you want to see all database connections, regardless of their source. |
Users Grid |
|
Database |
The database name that the user is connected to. |
Login |
The login of the user. |
Host |
The host computer that the login is coming from. |
Login Time |
The time the user logged into the database. |
Last Activity |
The last activity time against the database (e.g. read/write). |
SPID |
The ID assigned by SQL server for this connection. |
Program |
The executable program name making the connection. |
CPU Time |
Amount of CPU time used since connecting. |
Disk IO |
Amount of disk input/output used since connecting. |
Deleting a connection
1.You must be logged in as an admin (sa) user to delete SQL connections.
2.Open User inquiry from the Menu bar under System, Inquires.
3.Highlight the user you want to clear and then click on the Delete button 
You will get a message similar to the one below. Click OK to disconnect the user.
