Friday, March 9, 2012

Enterprise Manager locks on expanding databases folder

I'm having a very irritating situation occur with
Enterprise Manager.
I expand the databases folder after logging in to our
server and the application goes into 'not responding' mode.
There are about 200 databases to list, so I tried just
putting it in background... for four hours !!!!!
I killed the EM and tried this repeatedly, to no avail.
Does anyone know why this happens and what to do about it?Randy,
Are you on the latest service pack? Assuming its SQL2000, see
FIX: Opening the Database Folder in SQL Server Enterprise Manager 2000 Takes
a Long Time
http://support.microsoft.com/default.aspx?scid=kb;en-us;282416
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"randyv" <randy.volters@.whaleyfoodservice.com> wrote in message
news:061001c361d3$4bd83480$a101280a@.phx.gbl...
> I'm having a very irritating situation occur with
> Enterprise Manager.
> I expand the databases folder after logging in to our
> server and the application goes into 'not responding' mode.
> There are about 200 databases to list, so I tried just
> putting it in background... for four hours !!!!!
> I killed the EM and tried this repeatedly, to no avail.
> Does anyone know why this happens and what to do about it?|||> Does anyone know why this happens and what to do about it?
http://www.aspfaq.com/2469

No comments:

Post a Comment