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:
Showing posts with label sp3. Show all posts
Showing posts with label sp3. Show all posts
Thursday, March 22, 2012
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
> > >
> >
> >
> >
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
> > >
> >
> >
> >
Wednesday, March 21, 2012
Enterprise Manager very slow on XP Pro
Hi,
I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
same version of SQL installed on W2K / P3. The Enterprise Manager seems to
run much slower on XP than on W2K. A simple click in the left pane (e.g. on
'databases') results in 20-30 second wait (the disk led is lit solid during
that time).
Could anyone please give me any suggestions as to what I should be looking
for on the XP machine?
Thanks,
Bogdan
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
to
> run much slower on XP than on W2K. A simple click in the left pane (e.g.
on
> 'databases') results in 20-30 second wait (the disk led is lit solid
during
> that time).
Do please check if your databases have the autoclose option turned on. This
is default for Personal edition, and it takes time to open all databases.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Also verify that you have no ODBC tracing turned on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message
news:u2kKHRKRFHA.3704@.TK2MSFTNGP12.phx.gbl...
> to
> on
> during
> Do please check if your databases have the autoclose option turned on. This
> is default for Personal edition, and it takes time to open all databases.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
|||Neither of the databases had auto-close enabled. The ODBC tracing was not
enabled (although I'm not using ODBC to connect to any of the databases and
I hope that Enterprise Manager does not use it either).
What seemed to work was SP3a. I applied it last night and things appear to
be 'normal' now.
Dejan, Tibor: thanks for your responses.
Bogdan
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||> I hope that Enterprise Manager does not use it either).
Both EM and QA uses ODBC.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bogdan" <someone@.domain.com> wrote in message news:e3FUs4URFHA.3944@.TK2MSFTNGP10.phx.gbl...
> Neither of the databases had auto-close enabled. The ODBC tracing was not enabled (although I'm
> not using ODBC to connect to any of the databases and I hope that Enterprise Manager does not use
> it either).
> What seemed to work was SP3a. I applied it last night and things appear to be 'normal' now.
> Dejan, Tibor: thanks for your responses.
> Bogdan
>
> "Bogdan" <someone@.domain.com> wrote in message news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
>
|||Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com
|||If you want fast access to your database try SQL Admin Studio from
www.simego.com as this tool is just amazingly fast at connecting and
browsing SQL Server Databases.
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||Another way that I've seen autoclose turned on is when
moving a database from MSDE to MSSQL.
MSDE, IIRC, defaults to autoclose on.
jg
Originally posted by David Gugick
Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com
I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
same version of SQL installed on W2K / P3. The Enterprise Manager seems to
run much slower on XP than on W2K. A simple click in the left pane (e.g. on
'databases') results in 20-30 second wait (the disk led is lit solid during
that time).
Could anyone please give me any suggestions as to what I should be looking
for on the XP machine?
Thanks,
Bogdan
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
to
> run much slower on XP than on W2K. A simple click in the left pane (e.g.
on
> 'databases') results in 20-30 second wait (the disk led is lit solid
during
> that time).
Do please check if your databases have the autoclose option turned on. This
is default for Personal edition, and it takes time to open all databases.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Also verify that you have no ODBC tracing turned on.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message
news:u2kKHRKRFHA.3704@.TK2MSFTNGP12.phx.gbl...
> to
> on
> during
> Do please check if your databases have the autoclose option turned on. This
> is default for Personal edition, and it takes time to open all databases.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
|||Neither of the databases had auto-close enabled. The ODBC tracing was not
enabled (although I'm not using ODBC to connect to any of the databases and
I hope that Enterprise Manager does not use it either).
What seemed to work was SP3a. I applied it last night and things appear to
be 'normal' now.
Dejan, Tibor: thanks for your responses.
Bogdan
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||> I hope that Enterprise Manager does not use it either).
Both EM and QA uses ODBC.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bogdan" <someone@.domain.com> wrote in message news:e3FUs4URFHA.3944@.TK2MSFTNGP10.phx.gbl...
> Neither of the databases had auto-close enabled. The ODBC tracing was not enabled (although I'm
> not using ODBC to connect to any of the databases and I hope that Enterprise Manager does not use
> it either).
> What seemed to work was SP3a. I applied it last night and things appear to be 'normal' now.
> Dejan, Tibor: thanks for your responses.
> Bogdan
>
> "Bogdan" <someone@.domain.com> wrote in message news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
>
|||Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com
|||If you want fast access to your database try SQL Admin Studio from
www.simego.com as this tool is just amazingly fast at connecting and
browsing SQL Server Databases.
"Bogdan" <someone@.domain.com> wrote in message
news:%237JkLWIRFHA.1416@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I have SQL 2000 Personal Edition / SP3 on XP Pro, P4/HT. I also have the
> same version of SQL installed on W2K / P3. The Enterprise Manager seems
> to run much slower on XP than on W2K. A simple click in the left pane
> (e.g. on 'databases') results in 20-30 second wait (the disk led is lit
> solid during that time).
> Could anyone please give me any suggestions as to what I should be looking
> for on the XP machine?
> Thanks,
> Bogdan
>
|||Another way that I've seen autoclose turned on is when
moving a database from MSDE to MSSQL.
MSDE, IIRC, defaults to autoclose on.
jg
Quote:
Dejan Sarka wrote:
> Do please check if your databases have the autoclose option turned
> on. This is default for Personal edition, and it takes time to open
> all databases.
I've had a laptop that's been slow for months with QA and SQL EM and
it's been driving me crazy. Even pressing the Cancel button from the
Database properties in SQL EM caused undue database and disk activity.
Checked the databases, and sure enough, there was one user database that
mysteriously had Auto Close turned on. Probably turned it on for testing
and forgot to turn it off.
You fixed me. Thanks.
David Gugick
Imceda Software
www.imceda.com
Enterprise Manager Unknown Error
I am running SQL2000 sp3 with 819 hotfix on a 2003
Cluster. When I am on one of the database servers in the
cluster I can select from a table and get data returned.
When I am on the webserver and use EnterPrise I can see
the tables but when I try to select I get 'Unknown Error'.
The same select works from ISQL/W GUI and isql at the
command line while on the webserver.
Any ideas on what to look for would be helpful, nothing is
being logged in the eventlog or the sql log.
Thanks
Check the following;
- The MDAC version on the good and the bad machine. If possible upgrade to
the latest version of MDAC
- Capture the T-SQL command from profiler while you are try to retrieve the
data and see if you can identify the issue.
- Permissions
- The client configuration options by comparing them to the good machine.
HTH
SQL Server Support
Agnes Panosian
Cluster. When I am on one of the database servers in the
cluster I can select from a table and get data returned.
When I am on the webserver and use EnterPrise I can see
the tables but when I try to select I get 'Unknown Error'.
The same select works from ISQL/W GUI and isql at the
command line while on the webserver.
Any ideas on what to look for would be helpful, nothing is
being logged in the eventlog or the sql log.
Thanks
Check the following;
- The MDAC version on the good and the bad machine. If possible upgrade to
the latest version of MDAC
- Capture the T-SQL command from profiler while you are try to retrieve the
data and see if you can identify the issue.
- Permissions
- The client configuration options by comparing them to the good machine.
HTH
SQL Server Support
Agnes Panosian
Monday, March 19, 2012
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Enterprise Manager runs slow on some computers
I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Wednesday, March 7, 2012
Enterprise Manager Hangs
Everytime I try to use the Enterprise Manager tool to
access my SQL 2000 (sp3) server on a W2K3 Enterprise
machine it hangs (stops responding). The tool loads
correctly but when I dig down the tree to get at the
instance on the local machine it stops responding when
trying to Establish the Connection and checking Windows
Security.
The server is loading and running, but I can't make any
new databases.
I can stop and start the server.
I have tried reinstalling. I have checked that the
services are running correctly.Hi, please verify permissions on folder Microsoft SQL Server.
Verify if you services account have permissions on foder MSSQL
Verify the event viewer to view if you have more messages about mssqlserver
The problem is generally by permissions
I hope help you
Carlos Augusto
Bogot=E1 Colombia
>--Original Message--
>Everytime I try to use the Enterprise Manager tool to >access my SQL 2000 (sp3) server on a W2K3 Enterprise >machine it hangs (stops responding). The tool loads >correctly but when I dig down the tree to get at the >instance on the local machine it stops responding when >trying to Establish the Connection and checking Windows >Security.
>The server is loading and running, but I can't make any >new databases.
>I can stop and start the server.
>I have tried reinstalling. I have checked that the >services are running correctly.
>.
>
access my SQL 2000 (sp3) server on a W2K3 Enterprise
machine it hangs (stops responding). The tool loads
correctly but when I dig down the tree to get at the
instance on the local machine it stops responding when
trying to Establish the Connection and checking Windows
Security.
The server is loading and running, but I can't make any
new databases.
I can stop and start the server.
I have tried reinstalling. I have checked that the
services are running correctly.Hi, please verify permissions on folder Microsoft SQL Server.
Verify if you services account have permissions on foder MSSQL
Verify the event viewer to view if you have more messages about mssqlserver
The problem is generally by permissions
I hope help you
Carlos Augusto
Bogot=E1 Colombia
>--Original Message--
>Everytime I try to use the Enterprise Manager tool to >access my SQL 2000 (sp3) server on a W2K3 Enterprise >machine it hangs (stops responding). The tool loads >correctly but when I dig down the tree to get at the >instance on the local machine it stops responding when >trying to Establish the Connection and checking Windows >Security.
>The server is loading and running, but I can't make any >new databases.
>I can stop and start the server.
>I have tried reinstalling. I have checked that the >services are running correctly.
>.
>
Sunday, February 26, 2012
Enterprise Manager crashes
Using SQL Server 2000 SP3 Developer Edition and MDAC 2.7
After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?
ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.
G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.
After installing SP3 to my desktop to inoculate against the Slammer worm, Enterprise Manager started crashing with the following whenever I try to open database properties with the following: The instruction at "0x4247b98b" referenced memory at "0x0000001c" could not be 'read'. I've reinstalled SQL Server and the MDAC to no avail. Has anyone else had this and are there any ideas for possible solutions?
ThanksYou might want to take a look at the error log to see which component is failing. There is a known issue with DTSUI.DLL after installing sp3. You will have to contact PSS to get the fix.
G'luck.|||Get SQLDMO.DLL from \Program Files\Microsoft SQL Server\80\Tools\Binn and SQLDMO.rll from Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033 and Register it again using the REGSVR32 command.
We use to have the same problem now everything seems to be working fine.|||I was never able to get sqldmo.rll to register, as regsvr32 said that it only liked to register dll's and ocx's. But, moving the 2 files to the system32 folder replaced some really old ones and fixed the problem. Thanks for your help!|||Just be carefule the next time when you uninstall any user application as it tends to take away the SQLDMO.dll,which again results in the same thing.
Sunday, February 19, 2012
enterprise manager alignment problem
Hi,
After I installed SP3 for MSSQL 2000, the display in the enterprise manager
is not as before. There is an alignment problem of right to left.
For example when displaying all rows of a table, the rows of the datagarid
are aligned
to the right instead to the left.
How can I fix it?
--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@.bgumail.bgu.ac.ilHi Sue,
Yes, the locale (in the regional settings) are set to English(United
States).
It was OK before I installed SP3. It only started after SP3 was installed.
Ohad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
> I've seen this once or twice before with different regional
> settings. Is your locale set to English(United States) ? If
> not, try setting to that and see if the alignment goes back
> to what you expected.
> -Sue
> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
> <ohadyn@.bgumail.bgu.ac.il> wrote:
> >Hi,
> >After I installed SP3 for MSSQL 2000, the display in the enterprise
manager
> >is not as before. There is an alignment problem of right to left.
> >For example when displaying all rows of a table, the rows of the
datagarid
> >are aligned
> >to the right instead to the left.
> >
> >How can I fix it?
>|||I'm out of ideas - I've only seen it with the locale issue.
I'd check that the same SPs were applied to server and
clients. I'd check MDAC configuration/versions as well.
Maybe someone else has some ideas on whatever else could be
going on.
-Sue
On Tue, 26 Aug 2003 20:41:40 +0200, "Ohad Young"
<ohadyn@.bgumail.bgu.ac.il> wrote:
>Hi Sue,
>Yes, the locale (in the regional settings) are set to English(United
>States).
>It was OK before I installed SP3. It only started after SP3 was installed.
>Ohad
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
>> I've seen this once or twice before with different regional
>> settings. Is your locale set to English(United States) ? If
>> not, try setting to that and see if the alignment goes back
>> to what you expected.
>> -Sue
>> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
>> <ohadyn@.bgumail.bgu.ac.il> wrote:
>> >Hi,
>> >After I installed SP3 for MSSQL 2000, the display in the enterprise
>manager
>> >is not as before. There is an alignment problem of right to left.
>> >For example when displaying all rows of a table, the rows of the
>datagarid
>> >are aligned
>> >to the right instead to the left.
>> >
>> >How can I fix it?
>|||Hi Ohad,
This problem is strange. Do you mean the SQL Enterprise Manager and SQL
Server are installed on the same machine? Does this problem occur on the
other computer? Maybe you could try to reinstall the SQL Server Enterprise
Manager, and then check to see if the problem occurs again. For more
information regarding installing the SQL Server Enterprise Manager, please
refer to the article below:
This step-by-step guide describes how to install a SQL Server 2000 basic
local installation.
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
http://support.microsoft.com/?id=303747
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
I have the same alignment problem with EM sp3 on both WinXP and Win2K.
When the locale is set to Hebrew, the EM screens (layout and data) are
aligned to the right.
Changing the locale to English fixes the problem on both platforms.
I must use hebrew as my locale, otherwise outlook and other apps
display hebrew text as gibberish...
Ofer
v-yshao@.online.microsoft.com (Michael Shao [MSFT]) wrote in message news:<YevPw1JbDHA.2116@.cpmsftngxa06.phx.gbl>...
> Hi Ohad,
> This problem is strange. Do you mean the SQL Enterprise Manager and SQL
> Server are installed on the same machine? Does this problem occur on the
> other computer? Maybe you could try to reinstall the SQL Server Enterprise
> Manager, and then check to see if the problem occurs again. For more
> information regarding installing the SQL Server Enterprise Manager, please
> refer to the article below:
> This step-by-step guide describes how to install a SQL Server 2000 basic
> local installation.
> 303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
> http://support.microsoft.com/?id=303747
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.|||Hello Ohad,
My name is Venu Cherukupalli and I will be the
support engineer working with you on this issue. I have sent an EMail to
you regarding the action plan but I did not get any response. As per that
Email, the action plan is
1) Send me a screenshot of the Enterprise Manager which is posing problems.
2) Using Access, try to create a Linked Table to a SQL Server and see if
you notice the same problem in the designer.
Let me know if you have any questions or concerns.
Thanks
Venu Cherukupalli
Microsoft SQL Server Support
After I installed SP3 for MSSQL 2000, the display in the enterprise manager
is not as before. There is an alignment problem of right to left.
For example when displaying all rows of a table, the rows of the datagarid
are aligned
to the right instead to the left.
How can I fix it?
--
Ohad Young
Medical Informatics Research Center
Ben Gurion University
Information System Eng
Office Phone: 972-8-6477160
Cellular Phone: 972-54-518301
E-Mail: ohadyn@.bgumail.bgu.ac.ilHi Sue,
Yes, the locale (in the regional settings) are set to English(United
States).
It was OK before I installed SP3. It only started after SP3 was installed.
Ohad
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
> I've seen this once or twice before with different regional
> settings. Is your locale set to English(United States) ? If
> not, try setting to that and see if the alignment goes back
> to what you expected.
> -Sue
> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
> <ohadyn@.bgumail.bgu.ac.il> wrote:
> >Hi,
> >After I installed SP3 for MSSQL 2000, the display in the enterprise
manager
> >is not as before. There is an alignment problem of right to left.
> >For example when displaying all rows of a table, the rows of the
datagarid
> >are aligned
> >to the right instead to the left.
> >
> >How can I fix it?
>|||I'm out of ideas - I've only seen it with the locale issue.
I'd check that the same SPs were applied to server and
clients. I'd check MDAC configuration/versions as well.
Maybe someone else has some ideas on whatever else could be
going on.
-Sue
On Tue, 26 Aug 2003 20:41:40 +0200, "Ohad Young"
<ohadyn@.bgumail.bgu.ac.il> wrote:
>Hi Sue,
>Yes, the locale (in the regional settings) are set to English(United
>States).
>It was OK before I installed SP3. It only started after SP3 was installed.
>Ohad
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:sk5nkvs4if89v4b4818db6lh5n7gld9m6i@.4ax.com...
>> I've seen this once or twice before with different regional
>> settings. Is your locale set to English(United States) ? If
>> not, try setting to that and see if the alignment goes back
>> to what you expected.
>> -Sue
>> On Tue, 26 Aug 2003 19:37:12 +0200, "Ohad Young"
>> <ohadyn@.bgumail.bgu.ac.il> wrote:
>> >Hi,
>> >After I installed SP3 for MSSQL 2000, the display in the enterprise
>manager
>> >is not as before. There is an alignment problem of right to left.
>> >For example when displaying all rows of a table, the rows of the
>datagarid
>> >are aligned
>> >to the right instead to the left.
>> >
>> >How can I fix it?
>|||Hi Ohad,
This problem is strange. Do you mean the SQL Enterprise Manager and SQL
Server are installed on the same machine? Does this problem occur on the
other computer? Maybe you could try to reinstall the SQL Server Enterprise
Manager, and then check to see if the problem occurs again. For more
information regarding installing the SQL Server Enterprise Manager, please
refer to the article below:
This step-by-step guide describes how to install a SQL Server 2000 basic
local installation.
303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
http://support.microsoft.com/?id=303747
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
I have the same alignment problem with EM sp3 on both WinXP and Win2K.
When the locale is set to Hebrew, the EM screens (layout and data) are
aligned to the right.
Changing the locale to English fixes the problem on both platforms.
I must use hebrew as my locale, otherwise outlook and other apps
display hebrew text as gibberish...
Ofer
v-yshao@.online.microsoft.com (Michael Shao [MSFT]) wrote in message news:<YevPw1JbDHA.2116@.cpmsftngxa06.phx.gbl>...
> Hi Ohad,
> This problem is strange. Do you mean the SQL Enterprise Manager and SQL
> Server are installed on the same machine? Does this problem occur on the
> other computer? Maybe you could try to reinstall the SQL Server Enterprise
> Manager, and then check to see if the problem occurs again. For more
> information regarding installing the SQL Server Enterprise Manager, please
> refer to the article below:
> This step-by-step guide describes how to install a SQL Server 2000 basic
> local installation.
> 303747 HOW TO: Install SQL Server 2000 - Basic Local Installation
> http://support.microsoft.com/?id=303747
> Regards,
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.|||Hello Ohad,
My name is Venu Cherukupalli and I will be the
support engineer working with you on this issue. I have sent an EMail to
you regarding the action plan but I did not get any response. As per that
Email, the action plan is
1) Send me a screenshot of the Enterprise Manager which is posing problems.
2) Using Access, try to create a Linked Table to a SQL Server and see if
you notice the same problem in the designer.
Let me know if you have any questions or concerns.
Thanks
Venu Cherukupalli
Microsoft SQL Server Support
Friday, February 17, 2012
enterprise manager
Hi all,
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!
It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!
It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>
enterprise manager
Hi all,
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>|||Hi Kathy,
There's a very simple workaround for the scripting error you're
encountering in Enterprise Manager.
Just right-click on the DB, click view, then click list to display the
DB objects. Go back, right-click on the DB, click view, then click
Taskpad. It will reset the web interface and it'll work again.
Yes, another stupid bug in MSSQL SQL Server.
Best Regards,
Chuck Lee
chucksql@.hotmail.com
chucklee
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message205074.html
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>|||Hi Kathy,
There's a very simple workaround for the scripting error you're
encountering in Enterprise Manager.
Just right-click on the DB, click view, then click list to display the
DB objects. Go back, right-click on the DB, click view, then click
Taskpad. It will reset the web interface and it'll work again.
Yes, another stupid bug in MSSQL SQL Server.
Best Regards,
Chuck Lee
chucksql@.hotmail.com
chucklee
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message205074.html
Enterprise Manager
SQL 2000, Sp3
No items is displayed in the Enterprise Manager. All systems are
functioning properly, the EM is simply no longer useful. Any suggestions or
thoughts are appreciated.Well, for starters, you can achieve most things (and better, as a bonus)
using query analyzer.
You could also try re-installing client tools (or installing client tools
for SQL Server 2005, if you have them available).
Might be helpful to see a screen shot of what "no items is displayed"
means... is it possible the user you are connecting with has changed
permissions (and you are trying to see a list of tables, for example)? Have
you tried re-registering the server, and/or connecting using windows
authentication with a local or domain administrator?
"Mark Castelli" <mcastelli98@.yahoo.com> wrote in message
news:%23QM1jUJyHHA.4264@.TK2MSFTNGP05.phx.gbl...
> SQL 2000, Sp3
> No items is displayed in the Enterprise Manager. All systems are
> functioning properly, the EM is simply no longer useful. Any suggestions
> or thoughts are appreciated.
>
No items is displayed in the Enterprise Manager. All systems are
functioning properly, the EM is simply no longer useful. Any suggestions or
thoughts are appreciated.Well, for starters, you can achieve most things (and better, as a bonus)
using query analyzer.
You could also try re-installing client tools (or installing client tools
for SQL Server 2005, if you have them available).
Might be helpful to see a screen shot of what "no items is displayed"
means... is it possible the user you are connecting with has changed
permissions (and you are trying to see a list of tables, for example)? Have
you tried re-registering the server, and/or connecting using windows
authentication with a local or domain administrator?
"Mark Castelli" <mcastelli98@.yahoo.com> wrote in message
news:%23QM1jUJyHHA.4264@.TK2MSFTNGP05.phx.gbl...
> SQL 2000, Sp3
> No items is displayed in the Enterprise Manager. All systems are
> functioning properly, the EM is simply no longer useful. Any suggestions
> or thoughts are appreciated.
>
enterprise manager
Hi all,
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>
I have setup a new test server running sql2k sp3 on sbs2003. I have my
client machine which is just running sql2k on windows 2000. Is it safe to
use enterprise manager on my machine (no sp installed) to connect to the
sql2k sp3 server? Or is it recommended I install sp3 on mine too?
thanks!It is ideal to have your client utilitys at SP3 level also as there are
changes to the SQL-DMO dlls etc. which SEM uses
"RP" <rp@.nospam.com> wrote in message
news:eljLjGiIEHA.1944@.TK2MSFTNGP11.phx.gbl...
> Hi all,
> I have setup a new test server running sql2k sp3 on sbs2003. I have my
> client machine which is just running sql2k on windows 2000. Is it safe to
> use enterprise manager on my machine (no sp installed) to connect to the
> sql2k sp3 server? Or is it recommended I install sp3 on mine too?
> thanks!
>
Subscribe to:
Posts (Atom)