Enterprise Mgr. Won't Open

Here's a strange thing: I've had this installed for years, and it was working fine up until last night, after I installed the latest MS security updates.
After re-booting from that installation, I have not been able to open Enterprise Manager. I get an error titled Microsoft Management Console, then it tells me it has encountered a problem and needs to close.
I've uninstalled and re-installed the SQL Server 2000 client tools, but still get the same error. I've worked around it by running mmc.exe and adding the SQL Server snap-in, but would really like to fix this problem.
I can run mmc.exe, but as soon as I try to open SQL Server Enterprise Manager.msc, mmc crashes.
My OS is WinXP pro, sp 1. Anyone have any idea what's going on?
Thanks for any assistance,
Tom
This is getting stranger. I tried renaming the SQL Server Enterprise Manager.MSC to SQLServerEnterpriseManager.MSC, and it opens without any problem.
What's that all about?
tom
|||Hi Tom,
From your description, I understand that you would like to know why your
SQL Server Enterprise Manager crashes after your updating some Windows
Security Updates. Have I understood the issue correctly and completely? If
there is anything I misunderstood, please feel free to let me know.
I would like to collect some information about it
1. Do you use Windows Updates to do some updates and what updates have you
installed?
2. You could find SQLEM.msc from your SQL Server Install Disk and please
copy it to your SQL Client installed disk
(from CDROM\Enterprise\x86\binn\SQLEM.msc to SQLInstalledDisk\80\Tools\Binn
as SQL Server Enterprise Manager.msc)
Try to do this and see whethere it could solve your problems
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Michael,
I responded several days ago to your last post, however for some
reason my response was not posted. Here is the gist of it: (I posted
again tonight in the web based group, and the message did not post,
I'm using another newsgroup reader for this post).
I used Windows Update to install the latest security patches (WinXP
Pro).
I did several things, including following your suggestions, however
the only way to open EM was to rename the file. I first accidentally
found this out when I copied the file SQL Server Enterprise
Manager.MSC as test.msc to another directory.
Double clicking that file opened it with no problems. I then renamed
it to SQLServerEnterpriseManager.MSC, and it opened fine. However, if
I try to open it as SQL Server Enterprise Manager.MSC (with the
spaces), I get the error: Microsoft Management Console has encountered
a problem and needs to close.
I can open the file from the installation media (SQLEM.MSC), but as
soon as I rename it to SQL Server Enterprise Manager.MSC I get the
error.
I have no idea why this might be happening.
Tom
On Thu, 15 Apr 2004 08:07:11 GMT, v-mingqc@.online.microsoft.com
("Michael, Cheng [MST]") wrote:

>Hi Tom,
>From your description, I understand that you would like to know why your
>SQL Server Enterprise Manager crashes after your updating some Windows
>Security Updates. Have I understood the issue correctly and completely? If
>there is anything I misunderstood, please feel free to let me know.
>I would like to collect some information about it
>1. Do you use Windows Updates to do some updates and what updates have you
>installed?
>2. You could find SQLEM.msc from your SQL Server Install Disk and please
>copy it to your SQL Client installed disk
>(from CDROM\Enterprise\x86\binn\SQLEM.msc to SQLInstalledDisk\80\Tools\Binn
>as SQL Server Enterprise Manager.msc)
>Try to do this and see whethere it could solve your problems
>Thank you for your patience and cooperation. If you have any questions or
>concerns, don't hesitate to let me know. We are here to be of assistance!
>Sincerely yours,
>Michael Cheng
>Microsoft Online Support
>************************************************* **********
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and confers no rights.
>Please reply to newsgroups only, many thanks.
>
|||Hi Tom,
Would you please try following steps:
1. When opening SQL Server Enterprise Manager.MSC in mmc.exe, trying to
give a quotation marks like "SQL Server Enterprise Manager.MSC" and see
whether it will work fine.
2. Would you please check your SQL Server and MDAC versions to ensure they
are the latest ones?
3. Deleting the C:\Documents and Settings\<user-id>\Application
Data\Microsoft\MMC\SQL Server Enterprise Manager
try to see whethere it will work fine?
4. If you rename the file with blanks, such as "SQL SEM.msc" will it still
work fine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Michael,
Step #3 did the trick. Can you tell me what the problem was (i.e. why did it "break")?
Also, I'm hoping this posts on the newsgroup, as my posts lately don't seem to be "taking"...
Thanks for your help,
Tom
|||Hi Tom,
I am glad to hear that step #3 did the trick.
Based on my knowledge, on a Windows XP machine, the initial launch of SQL
Enterprise Manager creates a file (SQL Server Enterprise Manager) in
C:\Documents and Settings\<user-id>\Application Data\Microsoft\MMC.
Subsequent launches of Enterprise Manager use this file instead of the
original .msc file
Your Windows Security Updates or some other operations may make this file
corrupted. So you could not launch it unless you make it renamed. Renamed
file is recognized as new one, so it could be launched correctly.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

Enterprise Mgr. Won't Open

Here's a strange thing: I've had this installed for years, and it was workin
g fine up until last night, after I installed the latest MS security updates
.
After re-booting from that installation, I have not been able to open Enterp
rise Manager. I get an error titled Microsoft Management Console, then it te
lls me it has encountered a problem and needs to close.
I've uninstalled and re-installed the SQL Server 2000 client tools, but stil
l get the same error. I've worked around it by running mmc.exe and adding th
e SQL Server snap-in, but would really like to fix this problem.
I can run mmc.exe, but as soon as I try to open SQL Server Enterprise Manage
r.msc, mmc crashes.
My OS is WinXP pro, sp 1. Anyone have any idea what's going on?
Thanks for any assistance,
TomThis is getting stranger. I tried renaming the SQL Server Enterprise Manager
.MSC to SQLServerEnterpriseManager.MSC, and it opens without any problem.
What's that all about?
tom|||Hi Tom,
From your description, I understand that you would like to know why your
SQL Server Enterprise Manager crashes after your updating some Windows
Security Updates. Have I understood the issue correctly and completely? If
there is anything I misunderstood, please feel free to let me know.
I would like to collect some information about it
1. Do you use Windows Updates to do some updates and what updates have you
installed?
2. You could find SQLEM.msc from your SQL Server Install Disk and please
copy it to your SQL Client installed disk
(from CDROM\Enterprise\x86\binn\SQLEM.msc to SQLInstalledDisk\80\Tools\Binn
as SQL Server Enterprise Manager.msc)
Try to do this and see whethere it could solve your problems
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||Michael,
I responded several days ago to your last post, however for some
reason my response was not posted. Here is the gist of it: (I posted
again tonight in the web based group, and the message did not post,
I'm using another newsgroup reader for this post).
I used Windows Update to install the latest security patches (WinXP
Pro).
I did several things, including following your suggestions, however
the only way to open EM was to rename the file. I first accidentally
found this out when I copied the file SQL Server Enterprise
Manager.MSC as test.msc to another directory.
Double clicking that file opened it with no problems. I then renamed
it to SQLServerEnterpriseManager.MSC, and it opened fine. However, if
I try to open it as SQL Server Enterprise Manager.MSC (with the
spaces), I get the error: Microsoft Management Console has encountered
a problem and needs to close.
I can open the file from the installation media (SQLEM.MSC), but as
soon as I rename it to SQL Server Enterprise Manager.MSC I get the
error.
I have no idea why this might be happening.
Tom
On Thu, 15 Apr 2004 08:07:11 GMT, v-mingqc@.online.microsoft.com
("Michael, Cheng [MST]") wrote:

>Hi Tom,
>From your description, I understand that you would like to know why your
>SQL Server Enterprise Manager crashes after your updating some Windows
>Security Updates. Have I understood the issue correctly and completely? If
>there is anything I misunderstood, please feel free to let me know.
>I would like to collect some information about it
>1. Do you use Windows Updates to do some updates and what updates have you
>installed?
>2. You could find SQLEM.msc from your SQL Server Install Disk and please
>copy it to your SQL Client installed disk
>(from CDROM\Enterprise\x86\binn\SQLEM.msc to SQLInstalledDisk\80\Tools\Binn
>as SQL Server Enterprise Manager.msc)
>Try to do this and see whethere it could solve your problems
>Thank you for your patience and cooperation. If you have any questions or
>concerns, don't hesitate to let me know. We are here to be of assistance!
>Sincerely yours,
>Michael Cheng
>Microsoft Online Support
> ****************************************
*******************
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and confers no rights.
>Please reply to newsgroups only, many thanks.
>|||Hi Tom,
Would you please try following steps:
1. When opening SQL Server Enterprise Manager.MSC in mmc.exe, trying to
give a quotation marks like "SQL Server Enterprise Manager.MSC" and see
whether it will work fine.
2. Would you please check your SQL Server and MDAC versions to ensure they
are the latest ones?
3. Deleting the C:\Documents and Settings\<user-id>\Application
Data\Microsoft\MMC\SQL Server Enterprise Manager
try to see whethere it will work fine?
4. If you rename the file with blanks, such as "SQL SEM.msc" will it still
work fine?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||Michael,
Step #3 did the trick. Can you tell me what the problem was (i.e. why did it
"break")?
Also, I'm hoping this posts on the newsgroup, as my posts lately don't seem
to be "taking"...
Thanks for your help,
Tom|||Hi Tom,
I am glad to hear that step #3 did the trick.
Based on my knowledge, on a Windows XP machine, the initial launch of SQL
Enterprise Manager creates a file (SQL Server Enterprise Manager) in
C:\Documents and Settings\<user-id>\Application Data\Microsoft\MMC.
Subsequent launches of Enterprise Manager use this file instead of the
original .msc file
Your Windows Security Updates or some other operations may make this file
corrupted. So you could not launch it unless you make it renamed. Renamed
file is recognized as new one, so it could be launched correctly.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.sql

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.
Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:
> doug wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:
> doug wrote:
> > Yes, I do have 2 databases 'offline'.
> >
> > I do not get the arithmetic overflow error if I just select the dbid and the
> > name.
> >
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Quer
y
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one yo
u
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one
you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
>|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and t
he
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

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 unloading by itself

This is strange. My Enterprise Manager is unloading every
20 minutes by itself. This only after I modified the
MSSQLSERVER service to use an Administrator account
instead of Local System account so that I could use the
Debugger.
SQL2000 in SBS2000, all the latest patches.
Anyone else have this issue?
Thanx
SteveHi Steve,
What do you mean by "unloading"? If you mean crashing, you may want to see if you are hitting this issue
BUG: SQLBrowseConnect May Cause an Access Violation in the Client ID: 814064.KB.EN-US
http://support.microsoft.com/?id=814064
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| Content-Class: urn:content-classes:message
| From: "Steve Sklar" <stevesklar@.hotmail.com>
| Sender: "Steve Sklar" <stevesklar@.hotmail.com>
| Subject: Enterprise Manager unloading by itself
| Date: Thu, 25 Sep 2003 10:10:45 -0700
| Lines: 11
| Message-ID: <042201c38387$f52608c0$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcODh/UmCZPVXZcvRz6L79DbvkMDmA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308347
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| This is strange. My Enterprise Manager is unloading every
| 20 minutes by itself. This only after I modified the
| MSSQLSERVER service to use an Administrator account
| instead of Local System account so that I could use the
| Debugger.
|
| SQL2000 in SBS2000, all the latest patches.
| Anyone else have this issue?
|
| Thanx
| Steve
|sql

Enterprise Manager Showing Wrong Authentication Mechanism

This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:

>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:

> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:

> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>

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?
___________________________
Giacomo
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_backuphistoXry (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/default...b;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_backuphistoXry (see books online)
> Thanks
> Hari
> SQL Server MVP
>
>
> "Giacomo" <gdagostino@.vision2000.ca> wrote in message
> news:13AAF4E3-DF25-4839-B241-A573BA966E34@.microsoft.com...
>
>

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...
>
>

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/default.aspx?scid=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...
> > 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
>
>

Enterprise Manager Behaviour for SQL 2000

Thanks in Advance,
I am seeing a strange behavior in the query interface on EM that is
new for me, and it has only occurred in a new environment. So I
believe that this is a configuration setting that one of you can point
out to me.
We I have multiple query windows open, if I turn my attention to
another task in remote desktop, the reminder that a query window has
not been in use for sometime pops up and asks if it can clear the
results. In this environment, that window somehow gets trapped behind
the query windows. This creates a catch 22. I cannot move the focus
to close any of the query windows to reveal the system message, and I
cannot get to the system message to allow me to move the focus.
Is there a configuration solution here?
Mark Simmerman
Napa, CADon't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
Analyzer.
In Enteprise Manager, you are maintaining an association with the source
table (so that you can treat SQL Server like Excel, and edit a "cell"), and
this causes resource drain no matter how long you let it sit there.
<xxxdbaxxx@.gmail.com> wrote in message
news:1170262471.222466.129540@.l53g2000cwa.googlegroups.com...
> Thanks in Advance,
> I am seeing a strange behavior in the query interface on EM that is
> new for me, and it has only occurred in a new environment. So I
> believe that this is a configuration setting that one of you can point
> out to me.
> We I have multiple query windows open, if I turn my attention to
> another task in remote desktop, the reminder that a query window has
> not been in use for sometime pops up and asks if it can clear the
> results. In this environment, that window somehow gets trapped behind
> the query windows. This creates a catch 22. I cannot move the focus
> to close any of the query windows to reveal the system message, and I
> cannot get to the system message to allow me to move the focus.
> Is there a configuration solution here?
> Mark Simmerman
> Napa, CA
>|||On Jan 31, 10:52 am, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Don't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
> Analyzer.
> In Enteprise Manager, you are maintaining an association with the source
> table (so that you can treat SQL Server like Excel, and edit a "cell"), and
> this causes resource drain no matter how long you let it sit there.
> <xxxdba...@.gmail.com> wrote in message
> news:1170262471.222466.129540@.l53g2000cwa.googlegroups.com...
>
> > Thanks in Advance,
> > I am seeing a strange behavior in the query interface on EM that is
> > new for me, and it has only occurred in a new environment. So I
> > believe that this is a configuration setting that one of you can point
> > out to me.
> > We I have multiple query windows open, if I turn my attention to
> > another task in remote desktop, the reminder that a query window has
> > not been in use for sometime pops up and asks if it can clear the
> > results. In this environment, that window somehow gets trapped behind
> > the query windows. This creates a catch 22. I cannot move the focus
> > to close any of the query windows to reveal the system message, and I
> > cannot get to the system message to allow me to move the focus.
> > Is there a configuration solution here?
> > Mark Simmerman
> > Napa, CA- Hide quoted text -
> - Show quoted text -
OK. Other than telling me to use another tool (in SQL 2005 they are
one and the same), is there any solution or configuration setting that
can address this?
Mark|||> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same),
Yes, but you still have different options, like Open Table (bad), and query
windows (good).
> is there any solution or configuration setting that
> can address this?
Not that I know of.|||xxxdbaxxx@.gmail.com wrote:
> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same), is there any solution or configuration setting that
> can address this?
> Mark
>
No, they're not really "one and the same". You can "open" tables using
a GUI, ala Enterprise Manager, or you can query them properly ala Query
Analyzer. The only difference in 2005 is that you don't "launch" two
seperate applications.
The limitations are the same - opening a table through the GUI is a
heavy process, prone to blocking. The GUI tools are acceptable for a
development environment, but should not be used against a production
system. Manipulating your tables properly, using T-SQL commands, is the
preferred method.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||On Feb 1, 7:34 am, Tracy McKibben <t...@.realsqlguy.com> wrote:
> xxxdba...@.gmail.com wrote:
> > OK. Other than telling me to use another tool (in SQL 2005 they are
> > one and the same), is there any solution or configuration setting that
> > can address this?
> > Mark
> No, they're not really "one and the same". You can "open" tables using
> a GUI, ala Enterprise Manager, or you can query them properly ala Query
> Analyzer. The only difference in 2005 is that you don't "launch" two
> seperate applications.
> The limitations are the same - opening a table through the GUI is a
> heavy process, prone to blocking. The GUI tools are acceptable for a
> development environment, but should not be used against a production
> system. Manipulating your tables properly, using T-SQL commands, is the
> preferred method.
> --
> Tracy McKibben
> MCDBAhttp://www.realsqlguy.com
OK. I am in a development environment. I would still like to know if
anyone has an answer to the question. It is an annoying behavior on
the part of the GUI. Do you guys get points for non-responsive
responses?
Mark|||> OK. I am in a development environment. I would still like to know if
> anyone has an answer to the question. It is an annoying behavior on
> the part of the GUI. Do you guys get points for non-responsive
> responses?
We don't get "points" for anything. We are here, volunteering our time to
help other people solve problems we might have insight on. Every once in a
while, the recipients feigns appreciation.
If "not that I know of" is not responsive enough for you, then maybe you
know of a better place to get more responsive answers, and should try there.
<shrug><sigh><resisting smacking own forehead>

Enterprise Manager Behaviour for SQL 2000

Thanks in Advance,
I am seeing a strange behavior in the query interface on EM that is
new for me, and it has only occurred in a new environment. So I
believe that this is a configuration setting that one of you can point
out to me.
We I have multiple query windows open, if I turn my attention to
another task in remote desktop, the reminder that a query window has
not been in use for sometime pops up and asks if it can clear the
results. In this environment, that window somehow gets trapped behind
the query windows. This creates a catch 22. I cannot move the focus
to close any of the query windows to reveal the system message, and I
cannot get to the system message to allow me to move the focus.
Is there a configuration solution here?
Mark Simmerman
Napa, CA
Don't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
Analyzer.
In Enteprise Manager, you are maintaining an association with the source
table (so that you can treat SQL Server like Excel, and edit a "cell"), and
this causes resource drain no matter how long you let it sit there.
<xxxdbaxxx@.gmail.com> wrote in message
news:1170262471.222466.129540@.l53g2000cwa.googlegr oups.com...
> Thanks in Advance,
> I am seeing a strange behavior in the query interface on EM that is
> new for me, and it has only occurred in a new environment. So I
> believe that this is a configuration setting that one of you can point
> out to me.
> We I have multiple query windows open, if I turn my attention to
> another task in remote desktop, the reminder that a query window has
> not been in use for sometime pops up and asks if it can clear the
> results. In this environment, that window somehow gets trapped behind
> the query windows. This creates a catch 22. I cannot move the focus
> to close any of the query windows to reveal the system message, and I
> cannot get to the system message to allow me to move the focus.
> Is there a configuration solution here?
> Mark Simmerman
> Napa, CA
>
|||On Jan 31, 10:52 am, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Don't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
> Analyzer.
> In Enteprise Manager, you are maintaining an association with the source
> table (so that you can treat SQL Server like Excel, and edit a "cell"), and
> this causes resource drain no matter how long you let it sit there.
> <xxxdba...@.gmail.com> wrote in message
> news:1170262471.222466.129540@.l53g2000cwa.googlegr oups.com...
>
>
>
>
> - Show quoted text -
OK. Other than telling me to use another tool (in SQL 2005 they are
one and the same), is there any solution or configuration setting that
can address this?
Mark
|||> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same),
Yes, but you still have different options, like Open Table (bad), and query
windows (good).

> is there any solution or configuration setting that
> can address this?
Not that I know of.
|||xxxdbaxxx@.gmail.com wrote:
> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same), is there any solution or configuration setting that
> can address this?
> Mark
>
No, they're not really "one and the same". You can "open" tables using
a GUI, ala Enterprise Manager, or you can query them properly ala Query
Analyzer. The only difference in 2005 is that you don't "launch" two
seperate applications.
The limitations are the same - opening a table through the GUI is a
heavy process, prone to blocking. The GUI tools are acceptable for a
development environment, but should not be used against a production
system. Manipulating your tables properly, using T-SQL commands, is the
preferred method.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||On Feb 1, 7:34 am, Tracy McKibben <t...@.realsqlguy.com> wrote:
> xxxdba...@.gmail.com wrote:
>
> No, they're not really "one and the same". You can "open" tables using
> a GUI, ala Enterprise Manager, or you can query them properly ala Query
> Analyzer. The only difference in 2005 is that you don't "launch" two
> seperate applications.
> The limitations are the same - opening a table through the GUI is a
> heavy process, prone to blocking. The GUI tools are acceptable for a
> development environment, but should not be used against a production
> system. Manipulating your tables properly, using T-SQL commands, is the
> preferred method.
> --
> Tracy McKibben
> MCDBAhttp://www.realsqlguy.com
OK. I am in a development environment. I would still like to know if
anyone has an answer to the question. It is an annoying behavior on
the part of the GUI. Do you guys get points for non-responsive
responses?
Mark
|||> OK. I am in a development environment. I would still like to know if
> anyone has an answer to the question. It is an annoying behavior on
> the part of the GUI. Do you guys get points for non-responsive
> responses?
We don't get "points" for anything. We are here, volunteering our time to
help other people solve problems we might have insight on. Every once in a
while, the recipients feigns appreciation.
If "not that I know of" is not responsive enough for you, then maybe you
know of a better place to get more responsive answers, and should try there.
<shrug><sigh><resisting smacking own forehead>

Enterprise Manager Behaviour for SQL 2000

Thanks in Advance,
I am seeing a strange behavior in the query interface on EM that is
new for me, and it has only occurred in a new environment. So I
believe that this is a configuration setting that one of you can point
out to me.
We I have multiple query windows open, if I turn my attention to
another task in remote desktop, the reminder that a query window has
not been in use for sometime pops up and asks if it can clear the
results. In this environment, that window somehow gets trapped behind
the query windows. This creates a catch 22. I cannot move the focus
to close any of the query windows to reveal the system message, and I
cannot get to the system message to allow me to move the focus.
Is there a configuration solution here?
Mark Simmerman
Napa, CADon't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
Analyzer.
In Enteprise Manager, you are maintaining an association with the source
table (so that you can treat SQL Server like Excel, and edit a "cell"), and
this causes resource drain no matter how long you let it sit there.
<xxxdbaxxx@.gmail.com> wrote in message
news:1170262471.222466.129540@.l53g2000cwa.googlegroups.com...
> Thanks in Advance,
> I am seeing a strange behavior in the query interface on EM that is
> new for me, and it has only occurred in a new environment. So I
> believe that this is a configuration setting that one of you can point
> out to me.
> We I have multiple query windows open, if I turn my attention to
> another task in remote desktop, the reminder that a query window has
> not been in use for sometime pops up and asks if it can clear the
> results. In this environment, that window somehow gets trapped behind
> the query windows. This creates a catch 22. I cannot move the focus
> to close any of the query windows to reveal the system message, and I
> cannot get to the system message to allow me to move the focus.
> Is there a configuration solution here?
> Mark Simmerman
> Napa, CA
>|||On Jan 31, 10:52 am, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> Don't use "Open Table" in Enterprise Manager. Run a SELECT query in Query
> Analyzer.
> In Enteprise Manager, you are maintaining an association with the source
> table (so that you can treat SQL Server like Excel, and edit a "cell"), an
d
> this causes resource drain no matter how long you let it sit there.
> <xxxdba...@.gmail.com> wrote in message
> news:1170262471.222466.129540@.l53g2000cwa.googlegroups.com...
>
>
>
>
>
>
> - Show quoted text -
OK. Other than telling me to use another tool (in SQL 2005 they are
one and the same), is there any solution or configuration setting that
can address this?
Mark|||> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same),
Yes, but you still have different options, like Open Table (bad), and query
windows (good).

> is there any solution or configuration setting that
> can address this?
Not that I know of.|||xxxdbaxxx@.gmail.com wrote:
> OK. Other than telling me to use another tool (in SQL 2005 they are
> one and the same), is there any solution or configuration setting that
> can address this?
> Mark
>
No, they're not really "one and the same". You can "open" tables using
a GUI, ala Enterprise Manager, or you can query them properly ala Query
Analyzer. The only difference in 2005 is that you don't "launch" two
seperate applications.
The limitations are the same - opening a table through the GUI is a
heavy process, prone to blocking. The GUI tools are acceptable for a
development environment, but should not be used against a production
system. Manipulating your tables properly, using T-SQL commands, is the
preferred method.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||On Feb 1, 7:34 am, Tracy McKibben <t...@.realsqlguy.com> wrote:
> xxxdba...@.gmail.com wrote:
>
>
> No, they're not really "one and the same". You can "open" tables using
> a GUI, ala Enterprise Manager, or you can query them properly ala Query
> Analyzer. The only difference in 2005 is that you don't "launch" two
> seperate applications.
> The limitations are the same - opening a table through the GUI is a
> heavy process, prone to blocking. The GUI tools are acceptable for a
> development environment, but should not be used against a production
> system. Manipulating your tables properly, using T-SQL commands, is the
> preferred method.
> --
> Tracy McKibben
> MCDBAhttp://www.realsqlguy.com
OK. I am in a development environment. I would still like to know if
anyone has an answer to the question. It is an annoying behavior on
the part of the GUI. Do you guys get points for non-responsive
responses?
Mark|||> OK. I am in a development environment. I would still like to know if
> anyone has an answer to the question. It is an annoying behavior on
> the part of the GUI. Do you guys get points for non-responsive
> responses?
We don't get "points" for anything. We are here, volunteering our time to
help other people solve problems we might have insight on. Every once in a
while, the recipients feigns appreciation.
If "not that I know of" is not responsive enough for you, then maybe you
know of a better place to get more responsive answers, and should try there.
<shrug><sigh><resisting smacking own forehead>

Enterprise Manager

Hi,
I am using enterprise manager to manage various SQL servers however one
server that was working now refuses to connect/register again The strange
thing is that if I register the server in question it tries connect using
the wrong username (not the one I am logged on as. I cant find where it
caches/stores the old account details. How can I change the account in
question? We are using SQL & Windows Authenication.
CheersHi
In EM, right click on the server and select "SQL Server Registration
properties" and modify the login credentials.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mikecl" wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers
>
>|||Hi,
Thanks for the info however I am using windows authentication, when Em try;s
to connect/register with this server It connects using a domain\test account
which does not have rights. The other registered servers are connected using
my domain\user account.
Where or why does this setting get retained. If I delete the registration
and try reegister it again it allways uses the domain\test account but only
with that server.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
> > Hi,
> >
> > I am using enterprise manager to manage various SQL servers however one
> > server that was working now refuses to connect/register again The
strange
> > thing is that if I register the server in question it tries connect
using
> > the wrong username (not the one I am logged on as. I cant find where it
> > caches/stores the old account details. How can I change the account in
> > question? We are using SQL & Windows Authenication.
> >
> > Cheers
> >
> >
> >|||Hi,
U can use sp_password to change the default password for the user.
hope this help
from
doller
Mikecl wrote:
> Hi,
> I am using enterprise manager to manage various SQL servers however one
> server that was working now refuses to connect/register again The strange
> thing is that if I register the server in question it tries connect using
> the wrong username (not the one I am logged on as. I cant find where it
> caches/stores the old account details. How can I change the account in
> question? We are using SQL & Windows Authenication.
> Cheers|||Hi Mike,
Thanks for the info however I am using windows authentication and the
problem is the account it try's and connects with is not the one I am logged
on with e.g it uses domain\test account rather than domain\mike account.
Where/how does it cache this info. I have deleted and registered the server
but is makes no difference
Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:018438CC-21D1-4BF9-B0D7-F904B8D86BD7@.microsoft.com...
> Hi
> In EM, right click on the server and select "SQL Server Registration
> properties" and modify the login credentials.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mikecl" wrote:
> > Hi,
> >
> > I am using enterprise manager to manage various SQL servers however one
> > server that was working now refuses to connect/register again The
strange
> > thing is that if I register the server in question it tries connect
using
> > the wrong username (not the one I am logged on as. I cant find where it
> > caches/stores the old account details. How can I change the account in
> > question? We are using SQL & Windows Authenication.
> >
> > Cheers
> >
> >
> >