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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2005-12-03 : 07:01:43
|
| I want to detach a database but said that there are 3 connections using this database. How to find out who/which pc was connected to this database? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-03 : 07:11:08
|
| use sp_who-----------------[KH] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-03 : 07:16:31
|
| Alsosp_who2 and run profilerMadhivananFailing to plan is Planning to fail |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-03 : 15:22:58
|
You should be able to find out better from sp_who or sp_who2. Profiler is good for seeing the actual queries they are running and actions performed. They can have active connections though and not be doing anything. Profiler doesn't do such a good job of showing that. Just fyi.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 00:09:42
|
| Thanks Derrick MadhivananFailing to plan is Planning to fail |
|
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-05 : 00:46:53
|
| Hi,or use sp_who3 from Mr. Vyas site , http://vyaskn.tripod.com RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
|
|
|
|
Find out who connected to database