Enterprise Manager/Query Analyser hangs

Hi, hope somebody can help - we have found a strange problem at one of our
clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
when they click the + on Databases on Enterprise manager, it hangs and also
hangs the server (applications accessing the DB timeout). We found that user
sa did not have access to any DBs! -- which we restored with sp_changedbowner
- but still hangs! Query analyser also hangs when opening object browser. All
other actions also very slow. Have also checked and switched off autoclose on
all DBs.
Could not yet determine how and exactly when this happened.
Any advice appreciated.
Alice van Rensburg
>. We found that user
> sa did not have access to any DBs! --
sa is a sysadmin and has acceess by default to all databases
Is it poosible another actvities on the server?
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:B476EE93-18CB-4DCE-8D24-A80EE1062587@.microsoft.com...
> Hi, hope somebody can help - we have found a strange problem at one of our
> clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
> when they click the + on Databases on Enterprise manager, it hangs and
> also
> hangs the server (applications accessing the DB timeout). We found that
> user
> sa did not have access to any DBs! -- which we restored with
> sp_changedbowner
> - but still hangs! Query analyser also hangs when opening object browser.
> All
> other actions also very slow. Have also checked and switched off autoclose
> on
> all DBs.
> Could not yet determine how and exactly when this happened.
> Any advice appreciated.
> Alice van Rensburg
>
|||Thanx for your reply - the interesting thing is that user sa did have access
to all DBs when we last checked (in December) - something must have happened
to change that, but we do not know what. Have checked - nothing else running
on the SQL server. We are seriously considering uninstall and reinstall.
"Uri Dimant" wrote:

> sa is a sysadmin and has acceess by default to all databases
> Is it poosible another actvities on the server?
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:B476EE93-18CB-4DCE-8D24-A80EE1062587@.microsoft.com...
>
>
|||Managed to resolve this issue - seems like one of the dbs still had a
non-existing Windows NT user as dbowner. We detached all DBs, and reattached
them one by one, each time checking the owner and checking if DataBases
folder opens.
Regards
A
"Alice" wrote:
[vbcol=seagreen]
> Thanx for your reply - the interesting thing is that user sa did have access
> to all DBs when we last checked (in December) - something must have happened
> to change that, but we do not know what. Have checked - nothing else running
> on the SQL server. We are seriously considering uninstall and reinstall.
> "Uri Dimant" wrote:

Enterprise Manager/Query Analyser hangs

Hi, hope somebody can help - we have found a strange problem at one of our
clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
when they click the + on Databases on Enterprise manager, it hangs and also
hangs the server (applications accessing the DB timeout). We found that user
sa did not have access to any DBs! -- which we restored with sp_changedbowner
- but still hangs! Query analyser also hangs when opening object browser. All
other actions also very slow. Have also checked and switched off autoclose on
all DBs.
Could not yet determine how and exactly when this happened.
Any advice appreciated.
Alice van Rensburg>. We found that user
> sa did not have access to any DBs! --
sa is a sysadmin and has acceess by default to all databases
Is it poosible another actvities on the server?
"Alice" <Alice@.discussions.microsoft.com> wrote in message
news:B476EE93-18CB-4DCE-8D24-A80EE1062587@.microsoft.com...
> Hi, hope somebody can help - we have found a strange problem at one of our
> clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
> when they click the + on Databases on Enterprise manager, it hangs and
> also
> hangs the server (applications accessing the DB timeout). We found that
> user
> sa did not have access to any DBs! -- which we restored with
> sp_changedbowner
> - but still hangs! Query analyser also hangs when opening object browser.
> All
> other actions also very slow. Have also checked and switched off autoclose
> on
> all DBs.
> Could not yet determine how and exactly when this happened.
> Any advice appreciated.
> Alice van Rensburg
>|||Thanx for your reply - the interesting thing is that user sa did have access
to all DBs when we last checked (in December) - something must have happened
to change that, but we do not know what. Have checked - nothing else running
on the SQL server. We are seriously considering uninstall and reinstall.
"Uri Dimant" wrote:
> >. We found that user
> > sa did not have access to any DBs! --
> sa is a sysadmin and has acceess by default to all databases
> Is it poosible another actvities on the server?
>
> "Alice" <Alice@.discussions.microsoft.com> wrote in message
> news:B476EE93-18CB-4DCE-8D24-A80EE1062587@.microsoft.com...
> > Hi, hope somebody can help - we have found a strange problem at one of our
> > clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
> > when they click the + on Databases on Enterprise manager, it hangs and
> > also
> > hangs the server (applications accessing the DB timeout). We found that
> > user
> > sa did not have access to any DBs! -- which we restored with
> > sp_changedbowner
> > - but still hangs! Query analyser also hangs when opening object browser.
> > All
> > other actions also very slow. Have also checked and switched off autoclose
> > on
> > all DBs.
> > Could not yet determine how and exactly when this happened.
> > Any advice appreciated.
> > Alice van Rensburg
> >
>
>|||Managed to resolve this issue - seems like one of the dbs still had a
non-existing Windows NT user as dbowner. We detached all DBs, and reattached
them one by one, each time checking the owner and checking if DataBases
folder opens.
Regards
A
"Alice" wrote:
> Thanx for your reply - the interesting thing is that user sa did have access
> to all DBs when we last checked (in December) - something must have happened
> to change that, but we do not know what. Have checked - nothing else running
> on the SQL server. We are seriously considering uninstall and reinstall.
> "Uri Dimant" wrote:
> > >. We found that user
> > > sa did not have access to any DBs! --
> >
> > sa is a sysadmin and has acceess by default to all databases
> >
> > Is it poosible another actvities on the server?
> >
> >
> >
> > "Alice" <Alice@.discussions.microsoft.com> wrote in message
> > news:B476EE93-18CB-4DCE-8D24-A80EE1062587@.microsoft.com...
> > > Hi, hope somebody can help - we have found a strange problem at one of our
> > > clients (they run SQL srv 2000 with SP4 on Windows Server 2000 with SP3) -
> > > when they click the + on Databases on Enterprise manager, it hangs and
> > > also
> > > hangs the server (applications accessing the DB timeout). We found that
> > > user
> > > sa did not have access to any DBs! -- which we restored with
> > > sp_changedbowner
> > > - but still hangs! Query analyser also hangs when opening object browser.
> > > All
> > > other actions also very slow. Have also checked and switched off autoclose
> > > on
> > > all DBs.
> > > Could not yet determine how and exactly when this happened.
> > > Any advice appreciated.
> > > Alice van Rensburg
> > >
> >
> >
> >

Enterprise manager problem

hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guysTry adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.
****************************************
*********
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
****************************************
*********
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys

Enterprise manager problem

hi, i've just installed sql server2000 on my home pc, im using to connect to
a sql server at my work. My query analyser works fine, but enterprise manger
seems to freeze and ultimatly not respond when i try to open the data base
folder, I downloaded that latsest server packs, but evey time i rry to run
them I get a PackageForTheWeb error.
My home computer is using xp pro
im new comer to sql server, so if u have any suggestions please give like ur
explaining to a complete novice.
Thanks guys
Try adjusting your connection parameters -- try SQL Server authentication
credentials or Windows credentials. I would say go into SQL Client Network
utility, but I don't know what more that would offer when Query Analyzer
connects.
The one other thing to check is your version of ADO (look at properties for
c:\program files\common files\system\msado\msado15.dll). If it is less than
2.6 or 2.7, you might want to go to http://www.microsoft.com/ado and
grabbing the MDAC 2.8 release.

*************************************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.noreply.yahoo.com
Please remove "noreply" before replying.
This posting is provided "as is" with
no warranties and confers no rights.
*************************************************
"airwalker" <airwalker@.discussions.microsoft.com> wrote in message
news:1BB646CB-0EB7-4B70-9AC7-59538924B1E4@.microsoft.com...
> hi, i've just installed sql server2000 on my home pc, im using to connect
> to
> a sql server at my work. My query analyser works fine, but enterprise
> manger
> seems to freeze and ultimatly not respond when i try to open the data base
> folder, I downloaded that latsest server packs, but evey time i rry to run
> them I get a PackageForTheWeb error.
> My home computer is using xp pro
> im new comer to sql server, so if u have any suggestions please give like
> ur
> explaining to a complete novice.
> Thanks guys

Enterprise Manager and Query Analyser Hang-up

When I use the Query Analyser, I can view the data in one table. But if I
insert a row to the table, the Query Analyser hangs up. If I want to drop an
index from that table using the Enterprise Manager, it hangs up too. All the
other tables work fine. How can I solve it? Thanks.
Joe
Drop/Create INDEX requres page lock and hence nobody is available to use the
table till transaction will be commited. In fact Iwould do that by EM
because it has lots of lacks.
When you insert a row into the table check out that the table does not have
a trigger which may hangs up the application.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:FE0761E8-C157-4A45-BDB9-C7A4FDD63424@.microsoft.com...
> When I use the Query Analyser, I can view the data in one table. But if I
> insert a row to the table, the Query Analyser hangs up. If I want to drop
an
> index from that table using the Enterprise Manager, it hangs up too. All
the
> other tables work fine. How can I solve it? Thanks.

Enterprise Manager and Query Analyser Hang-up

When I use the Query Analyser, I can view the data in one table. But if I
insert a row to the table, the Query Analyser hangs up. If I want to drop an
index from that table using the Enterprise Manager, it hangs up too. All the
other tables work fine. How can I solve it? Thanks.Joe
Drop/Create INDEX requres page lock and hence nobody is available to use the
table till transaction will be commited. In fact Iwould do that by EM
because it has lots of lacks.
When you insert a row into the table check out that the table does not have
a trigger which may hangs up the application.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:FE0761E8-C157-4A45-BDB9-C7A4FDD63424@.microsoft.com...
> When I use the Query Analyser, I can view the data in one table. But if I
> insert a row to the table, the Query Analyser hangs up. If I want to drop
an
> index from that table using the Enterprise Manager, it hangs up too. All
the
> other tables work fine. How can I solve it? Thanks.

Enterprise Manager and Query Analyser Hang-up

When I use the Query Analyser, I can view the data in one table. But if I
insert a row to the table, the Query Analyser hangs up. If I want to drop an
index from that table using the Enterprise Manager, it hangs up too. All the
other tables work fine. How can I solve it? Thanks.Joe
Drop/Create INDEX requres page lock and hence nobody is available to use the
table till transaction will be commited. In fact Iwould do that by EM
because it has lots of lacks.
When you insert a row into the table check out that the table does not have
a trigger which may hangs up the application.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:FE0761E8-C157-4A45-BDB9-C7A4FDD63424@.microsoft.com...
> When I use the Query Analyser, I can view the data in one table. But if I
> insert a row to the table, the Query Analyser hangs up. If I want to drop
an
> index from that table using the Enterprise Manager, it hangs up too. All
the
> other tables work fine. How can I solve it? Thanks.

Enterprise Manager and its particularities

Dear all,
I'm fed up with this problem. I hate that behaviour.
When I create objects from a query analyser session in my own workstation,
then these objects doesn't visible from my MMC. A lot of times I am obligate
d
to close and open again.
I've got a MMC with 13 Sql Server and some of them are remote but I don't
think that that aspect could to interfere in the response for do a refresh.
In a fact I do highest level refresh but nothing happens, objects such as
views, sp or tables are missing.
It's a waste time. Why on earth is happening this?
Thanks a lot and regards,Enric wrote:
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own
> workstation, then these objects doesn't visible from my MMC. A lot of
> times I am obligated to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I
> don't think that that aspect could to interfere in the response for
> do a refresh. In a fact I do highest level refresh but nothing
> happens, objects such as views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,
I've seen a few others post this issue on SQL EM, but most of us here
have not experienced the problem. With me, anyway, a selecting the
Refresh context menu option performs the necessary refresh and the new
objects appear.
Can you document the steps to consistently reproduce the refresh issue
or is this something that does not occur with any consistency?
Also, what version of SQL EM are you using? Check Help | About and post
the full version.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Enric wrote:
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own
> workstation, then these objects doesn't visible from my MMC. A lot of
> times I am obligated to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I
> don't think that that aspect could to interfere in the response for
> do a refresh. In a fact I do highest level refresh but nothing
> happens, objects such as views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,
Clarification: For the version, just let us know what SQL Server service
pack you've installed on your client. The version appears to only show
the major version, not the SP level.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||What happend if instead closing, you just disconnect and connect agaiin to
the server?
AMB
"Enric" wrote:

> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own workstation,
> then these objects doesn't visible from my MMC. A lot of times I am obliga
ted
> to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I don't
> think that that aspect could to interfere in the response for do a refresh
.
> In a fact I do highest level refresh but nothing happens, objects such as
> views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,|||You need to refresh at the right level. Don't do the highest level. Refresh
doesn't work "all the
way down". Do refresh on the right container.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:259BA9D3-01BE-4962-8F1F-86EB413D4C32@.microsoft.com...
> Dear all,
> I'm fed up with this problem. I hate that behaviour.
> When I create objects from a query analyser session in my own workstation,
> then these objects doesn't visible from my MMC. A lot of times I am obliga
ted
> to close and open again.
> I've got a MMC with 13 Sql Server and some of them are remote but I don't
> think that that aspect could to interfere in the response for do a refresh
.
> In a fact I do highest level refresh but nothing happens, objects such as
> views, sp or tables are missing.
> It's a waste time. Why on earth is happening this?
> Thanks a lot and regards,|||EM is not "active" in the sense that it does not sense changes it does not
make. It is an application that initializes iteslf with data, and knows wha
t
IT does, but not what others (Query Analyzer) do until it re-selects data.
If you want to see new tables, right-click on the "tables" tree in the left
pane and select "refresh". Your new tables will now appear. You can refres
h
at various levels, but the higher-up you go, the longer it will take.
"David Gugick" wrote:

> Enric wrote:
> Clarification: For the version, just let us know what SQL Server service
> pack you've installed on your client. The version appears to only show
> the major version, not the SP level.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||Thanks to all for response.
Tibor,
Your fix not always works.
David,
All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
I think that it could be a network problem between domains or something like
that. There are two sql server which are living in an AD environment, the
rest one running under NT Domains.
Well, I also want understand that maybe to have so many servers at the same
time...
"Tibor Karaszi" wrote:

> You need to refresh at the right level. Don't do the highest level. Refres
h doesn't work "all the
> way down". Do refresh on the right container.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:259BA9D3-01BE-4962-8F1F-86EB413D4C32@.microsoft.com...
>|||Enric wrote:
> Thanks to all for response.
> Tibor,
> Your fix not always works.
> David,
> All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
> I think that it could be a network problem between domains or
> something like that. There are two sql server which are living in an
> AD environment, the rest one running under NT Domains.
>
Service Packs should be applied to the client as well as the server.
That's why I asked what version you have on the client. You can check
this from Query Analyzer on the client. You should be running 8.00.760
for SP3/SP3a.
It's possible the RTM release of SQL EM had refresh problems.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Hi
We have in excess of 95 servers in our EM at work, across multiple domains.
The SP is applied to both the servers and client workstations with EM
installed.
Right clicking as described by other posts in this thread works for us 100%
If you have networking problems between domains, you would get errors as the
objects are refreshed out of sysobjects in each database. It either works or
it gives you an error.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:CFD1B642-341C-4A97-8D0B-DFDBF16C15FF@.microsoft.com...
> Thanks to all for response.
> Tibor,
> Your fix not always works.
> David,
> All the SQL SERVERS (2000) own sp3 and sp3a for olap services.
> I think that it could be a network problem between domains or something
> like
> that. There are two sql server which are living in an AD environment, the
> rest one running under NT Domains.
> Well, I also want understand that maybe to have so many servers at the
> same
> time...
> "Tibor Karaszi" wrote:
>