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 |
|
Newbie2005
Starting Member
29 Posts |
 Posted - 2006-05-23 : 22:05:32
|
| How I can find a db in use or not? |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-05-23 : 22:09:36
|
| sp_who |
 |
|
|
Newbie2005
Starting Member
29 Posts |
Posted - 2006-05-23 : 22:17:18
|
| could you please give me a sample use? because only way seems to check if there is a user connected (login) or not. Thanks in advance. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-23 : 23:21:17
|
| go to enterprise manager, expand management then current activity then click on process info...--editfrom this post, i think you said you got it already?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66583--------------------keeping it simple... |
|
|
|
Newbie2005
Starting Member
29 Posts |
Posted - 2006-05-23 : 23:59:44
|
| There is a misunderstanding. I know sp_who and sp_who2. But how I will chek if a specific db is in use except checking users connected or not. Is there any other way? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-24 : 01:40:14
|
 a database is in use if someone is connected to itprovide a specific scenario, the question is not clear--------------------keeping it simple... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-05-24 : 02:30:10
|
| Maybe you can start a trace using Profiler. Monitor the activity on this one database for as long as is needed to see if anyone's using it. It should be quite easy to set up...look up "profiler" in BOL or ask your questions here and I'm sure you'll get what you need.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How I can find a db in use or not?