Can't Connect or see databases

I am having problem connecting to a database using EM or Query analyzer. Bot
h
applications start up fine. When I click on the database folder to expand it
in EM or the drop down in Query Analyzer, both applications hangs and nothin
g
happens. The SQL services started fine. Please help.
EmmaI just realized that I am only having problem connecting to one particular
db. I can connect to the other db on the server use the USE command in Query
Analyzer. When I try to connect to the offending database, QA just hangs
stating that it is executing query batch...
Any idea how I can correct this problem? The log file for the offending db
is full and I am trying to shrink it using dbcc.
Thenks
Emma
"Emma" wrote:

> I am having problem connecting to a database using EM or Query analyzer. B
oth
> applications start up fine. When I click on the database folder to expand
it
> in EM or the drop down in Query Analyzer, both applications hangs and noth
ing
> happens. The SQL services started fine. Please help.
> Emma
>|||Did you try backing up the log for the offending database
first? You can execute the statement from master.
-Sue
On Tue, 25 Jul 2006 06:59:02 -0700, Emma
<Emma@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>I just realized that I am only having problem connecting to one particular
>db. I can connect to the other db on the server use the USE command in Quer
y
>Analyzer. When I try to connect to the offending database, QA just hangs
>stating that it is executing query batch...
>Any idea how I can correct this problem? The log file for the offending db
>is full and I am trying to shrink it using dbcc.
>Thenks
>Emma
>"Emma" wrote:
>