Post
by Stellar » Wed 28 Mar 2018 10:59
In disconnected mode a connection is opened for executing requests to the server (if it was not opened already) and is closed automatically if it is not required any more. If the connection was explicitly opened (the Connect method was called or the Connected property was explicitly set to True), it does not close until the Disonnect method is called or the Connected property is set to False explicitly. Therefore, in order for disconnected mode to correctly work, software connection to the server is not required.
Yes, you can check which users are active in Management Studio, for example, by calling the sp_who procedure. If you use disconnected mode, then only active sessions should be displayed in the user list.