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 |
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
 Posted - 2008-03-14 : 16:01:36
|
| HOW DO WE CHECK ACTIVE SQL SERVER DATABASE?Please advice! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-14 : 22:00:53
|
| What do you mean? Whick machine is active node in the cluster? |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-15 : 06:45:56
|
| Do you want want to see if it's available?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sqlserverdbam
Yak Posting Veteran
54 Posts |
Posted - 2008-03-18 : 13:17:00
|
| I would like to know which databases are in use.Is there any way I can run sql or figure out when was database used by some one?Please advice.thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:51:13
|
| Run sp_who2, it'll list all connections and dbs used on the server. |
|
|
|
|
|
|
CHECK ACTIVE SQL SERVER DATABASE