"Biju" <biju@cyber-gear.com> wrote in message
news:12ad01c38647$906edb10$a301280a@phx.gbl...
> Hello:
>
> We are using MS SQL 2000 server on one of our
> sites. We are unable to access the databases folder in
> the server. After connecting to the server through
> Enterprise Manager and clicking on the databases folder,
> the server does not responds for long and later hangs. As
> mentioned by our server support we have installed the
> patches for 'SQL Server 2000 Service Pack 3a'. But still
> the problem is not solved.
>
> Can anyone help me on this.

"Biju" <biju@cyber-gear.com> wrote in message
news:1c9001c38672$f166b660$a301280a@phx.gbl...
> Yes we can go further with Query analyzer. The database
> is on a virtually hosted server. So there are multiple
> databases on the server. In our local server through with
> we are connecting, does not have much databases.
>
> Can this happen if the virtual memory is less on
> the system??
>
>
> >-----Original Message-----
> >Do you have a lot of databases ?
> >Can you get any further with Query Analyser ?
> >
> >--
> >
> >----------------------------
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> >"Biju" <biju@cyber-gear.com> wrote in message
> >news:12ad01c38647$906edb10$a301280a@phx.gbl...
> >> Hello:
> >>
> >> We are using MS SQL 2000 server on one of our
> >> sites. We are unable to access the databases folder in
> >> the server. After connecting to the server through
> >> Enterprise Manager and clicking on the databases
> folder,
> >> the server does not responds for long and later hangs.
> As
> >> mentioned by our server support we have installed the
> >> patches for 'SQL Server 2000 Service Pack 3a'. But
> still
> >> the problem is not solved.
> >>
> >> Can anyone help me on this.
> >
> >
> >.
> >