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 |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2008-11-11 : 14:59:40
|
| i was running a huge update and it bombed in the middle of update. after that i could not connect to query analyser. i have tried rebooting the box. Im able to open up enterprise manager and when i click databases, it just hangs displaying the hour glass. any idea? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-11 : 15:01:03
|
| It's due to Roll back.What do you see with sp_who2 active? |
 |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-11-11 : 15:02:07
|
| i could not open query analyser to issue the statement, also i went to current activity and dont see anything running |
|
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-11-11 : 15:07:36
|
| i see one activity "CHECKPOINT" . is this the problem |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
cbeganesh
Posting Yak Master
105 Posts |
Posted - 2008-11-11 : 15:20:34
|
| i guess i have to wait till the checkpoint is complted |
|
|
|
|
|
|
cannot connect to query analyser