Welsh Corgi (5/6/2013)
If someone has the sole connection I would not be able to kill their session?
You would be able to.
If someone has [grabbed the sole connection], identify who, ask them politely to log off (or kill their session), then access the DB again.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability