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 |
|
jpradeep
Starting Member
8 Posts |
 Posted - 2006-12-12 : 00:37:13
|
| Hi allHow to find how many connections established with same sql server database with same login & pwd from different/same system(s)?suppose if we connect same database with same login from 10 different systems and if one system crashed down (without disconncting sql server) is that count will be changed immediately? or do we need to do something like refresh before fetching count?Thanks in AdvancePradeep |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 01:06:03
|
| select * from master..sysprocesseslook at login_name Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Find connections with same login?