Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohitmathur11
Yak Posting Veteran
77 Posts |
 Posted - 2009-12-23 : 02:15:27
|
| Hi,i want to know how can we check that user loged in the database is active or sleeping ..? i used sp_who in this it is showing all users are in sleeping mode..I want to check that user sid number 100 is active or sleeping ..andafter how much time this user will be loged off automatically ..from database if it sleeping for that time like 10-15 minutes...?can i get ip address of the user's system who is connected to database ..? any idea.. Thanks |
|
|
rohitmathur11
Yak Posting Veteran
77 Posts |
Posted - 2009-12-28 : 00:49:25
|
| any idea about it...? |
 |
|
|
|
|
|
Active user