Enterprise Manager HANGS

For some strange reason we cannot connect to both our databases and
Enterprise manger hangs when we try loading it? anyone have any ideas?
--
___________________________
GiacomoHi,
2 reasons may be the cause:-
1. See if Autoclose option is enabled for the database. If it is enabled
then disable the database option. This option will close the database once
the last user logs off. So while connecting back it open the database back
again and take some time
2. This can be slow if you have more backup history. So delete the history
using:-
sp_delete_database_backuphisto_ry (see books online)
Thanks
Hari
SQL Server MVP
"Giacomo" <gdagostino@.vision2000.ca> wrote in message
news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
> For some strange reason we cannot connect to both our databases and
> Enterprise manger hangs when we try loading it? anyone have any ideas?
> --
>
> ___________________________
> Giacomo|||Giacomo
There was a problem like this with the early version of SQL Server 2000.
What service pack are you on? Have a look at this article, it may be your
problem.
http://support.microsoft.com/defaul...kb;en-us;282416
Hope this helps
John
"Hari Prasad" wrote:

> Hi,
> 2 reasons may be the cause:-
> 1. See if Autoclose option is enabled for the database. If it is enabled
> then disable the database option. This option will close the database once
> the last user logs off. So while connecting back it open the database back
> again and take some time
> 2. This can be slow if you have more backup history. So delete the history
> using:-
> sp_delete_database_backuphisto_ry (see books online)
> Thanks
> Hari
> SQL Server MVP
>
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
>
>