Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.
Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.

Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx
.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.

Can't access database

Please see threads below for sp_dboption.
I can't connect to the database via Query Analyser.
When I try to open the Databases folder in Enterprise
manager, it seems to hang.
The database affected is for testing only, so I am not
worried about that. I am worried about the server tho, as
it is a production server.Hi,
Can you check the SQL Server error logs in SQL Server program folder\logs
folder for any errors.
See like there is some issues in your test database.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:28d3c01c4642d$e3781460$a301280a@.phx.gbl...
> Please see threads below for sp_dboption.
> I can't connect to the database via Query Analyser.
> When I try to open the Databases folder in Enterprise
> manager, it seems to hang.
> The database affected is for testing only, so I am not
> worried about that. I am worried about the server tho, as
> it is a production server.