Enterprise Manger CLOSES!

Hello everyone,
I have SQL server 2000 installed on Windows 2003 std
edition. The first time I opened E manager I was able to
right click on any database and go to properties to set
the location of transaction logs and so forth! The second
time I went into it I tried the same thing and now E
manager shuts down. It does the same thing to all the
databases. Does anyone know why this is happening. I have
sp3 installed...
GiacomoI don't know what happening but my be able to supply
information for you to find out.
The 2003 should contain logs of programs / services that
have started an stopped including SQL Server, so have a
chat to your 2003 Administrator to see if you can have a
look at them.
SQL Server also keeps a log, under the server - Managment -
SQL Server Logs have a look at that and see if it helps.
Run a trace and see what the server was doing before the
shut down.
J
>--Original Message--
>Hello everyone,
>I have SQL server 2000 installed on Windows 2003 std
>edition. The first time I opened E manager I was able to
>right click on any database and go to properties to set
>the location of transaction logs and so forth! The second
>time I went into it I tried the same thing and now E
>manager shuts down. It does the same thing to all the
>databases. Does anyone know why this is happening. I have
>sp3 installed...
>Giacomo
>.
>

Enterprise Manager, table CreateDate doesn't sort correctly

In EM, when viewing the tables in a database, the tables do not sort
correctly by CreateDate when you click the header. However, in other
databases on the same server, it sorts correctly. Odd.
The only subtle difference we've found is that those databases where the
table create date displays with AM or PM sorts correctly. Those that
display the millisecond in the Create Date do not sort correctly?
Any ideas on how to solve this problem? Thanks in advance!
Mark
SQL Server 2000 with latest and greatest service packs> In EM, when viewing the tables in a database, the tables do not sort
> correctly by CreateDate when you click the header. However, in other
> databases on the same server, it sorts correctly. Odd.
I've seen this too, and can't explain it (nor do I know the fix). I'd show
you the article on my site, but a middleman provider is having issues.
If you really need this functionality, run a query from sysobjects WHERE
xtype='U' ORDER BY crdate DESC...
--
Aaron Bertrand
SQL Server MVP
> The only subtle difference we've found is that those databases where the
> table create date displays with AM or PM sorts correctly. Those that
> display the millisecond in the Create Date do not sort correctly?
> Any ideas on how to solve this problem? Thanks in advance!
> Mark
> SQL Server 2000 with latest and greatest service packs
>

Enterprise Manager very slowly

Hi,
Is there any parameters to configure to improve the performance in the
Enterprise Manager ? I have installed 7 small databases but when I click in
the "Databases" option, for example, I need to wait for several seconds (I
don´t think this is right). There are other options with the same problem.
It´s occur and my two machines (and I already see this in other machines),
the first running Windows 2003 Server Standard RC2 and the second running
Windows XP Professional, both with SQL Server 2000 - SP3.
Any suggest ?
Vitor Mauricio de N. Silva
Rio de Janeiro - BrazilVitor
Have you check odbc trace is running?
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>|||Perfect. I had some databases with the option AUTO CLOSE clicked. After
changed everything works fine.
Thanks,
Vitor Mauricio de N. Silva
Rio de Janeiro - Brazil
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service pack 3a. When I right click on Microsoft SQL Servers below the Console Root tree and I select About Sql Server Entrprise Manager, it shows version 8.00.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which is 8.00.760. I tried re-applying the service pack and rebooting and it still shows the incorrect version. Because of this, I am getting incorrect info through Taskpad View for the
correct table sizes in my database. Any ideas?
Thanks,
Nupee
> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)
|||I forgot to mention that this is through my SQL Server 2000 client addition on my desktop. There is nothing wrong with the actual SQL Server. I seem to be the only one in my group experiencing this problem. I am currently using Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it shows
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.
|||I have applied SP3 several times. Don't forget even without using Taskpad, when I check the version of my Entrprise Manager addition, it still does not reflect the SP3 being applied. I don't think this is a database issue. I think it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server. I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>
|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?
|||Yes that is the only instance. However, I do have reporting services loaded as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you have
> installed?
>
>
|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp 3a using a dos prompt and running the setup.bat file. When I tried to apply the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks away for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loaded as well.
> "Aaron [SQL Server MVP]" wrote:

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service
pack 3a. When I right click on Microsoft SQL Servers below the Console Root
tree and I select About Sql Server Entrprise Manager, it shows version 8.00
.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which
is 8.00.760. I tried re-applying the service pack and rebooting and it still
shows the incorrect version. Because of this, I am getting incorrect info t
hrough Taskpad View for the
correct table sizes in my database. Any ideas'
Thanks,
Nupee> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)|||I forgot to mention that this is through my SQL Server 2000 client addition
on my desktop. There is nothing wrong with the actual SQL Server. I seem to
be the only one in my group experiencing this problem. I am currently using
Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it sho
ws
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
>
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.|||I have applied SP3 several times. Don't forget even without using Taskpad, w
hen I check the version of my Entrprise Manager addition, it still does not
reflect the SP3 being applied. I don't think this is a database issue. I thi
nk it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server.
I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?|||Yes that is the only instance. However, I do have reporting services loaded
as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you hav
e
> installed?
>
>|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp
3a using a dos prompt and running the setup.bat file. When I tried to apply
the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks aw
ay for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loade
d as well.
> "Aaron [SQL Server MVP]" wrote:
>

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIA
Ken,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA
|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs)
where when I right click 'properties' of the table in Enterprise Manager I
get 13316 records. But if I open the table in enterprise manager and SELECT
count(*) I get 13315 recor
ds. However, using the same table in Query Analyzer, Select count(*) result
s in 13315 records and Select *
results in 13315 rows showing in the lower right of the Query pane.
It seems to be occuring in just this one table using Enterprise Manager.
Probably no big deal. Anyone know what may be causing this?
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIAsql

Enterprise Manager table property consistency

I have one table in my SQL server 2000 (w2k server up to date service packs) where when I right click 'properties' of the table in Enterprise Manager I get 13316 records. But if I open the table in enterprise manager and SELECT count(*) I get 13315 records. However, using the same table in Query Analyzer, Select count(*) results in 13315 records and Select
results in 13315 rows showing in the lower right of the Query pane
It seems to be occuring in just this one table using Enterprise Manager
Probably no big deal. Anyone know what may be causing this
TIAKen,
Refer DBCC UPDATEUSAGE in BooksOnLine.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA|||In addition to Dinesh's response, both counts and table/index sizes are
numbers that are NOT updated for each insert, update or delete. They are
periodically updated, so they will be close most of the time , but not
exact...
The command that Dinesh showed you will update the information.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Ken" <anonymous@.discussions.microsoft.com> wrote in message
news:53400F61-A8C3-4423-BCCA-B14A84E7FDBD@.microsoft.com...
> I have one table in my SQL server 2000 (w2k server up to date service
packs) where when I right click 'properties' of the table in Enterprise
Manager I get 13316 records. But if I open the table in enterprise manager
and SELECT count(*) I get 13315 records. However, using the same table in
Query Analyzer, Select count(*) results in 13315 records and Select *
> results in 13315 rows showing in the lower right of the Query pane.
> It seems to be occuring in just this one table using Enterprise Manager.
> Probably no big deal. Anyone know what may be causing this?
> TIA

Enterprise manager SQLServer2000

When I click on Enterprise manager->Database this is the error I am getting:
A runtime error has occurred. Do you wish to debug. Line 306 Error: unspecified error. Yes/No

This is happening on user databases only not the SQL standard dbs; pubs,master,northwind.

How can I fix this?

Thanks for any help.
VinnieAre you clicking from a client workstation, server console, server console through Terminal Services client, etc.? More details needed.|||I am clicking (Left click)
SQLServer Enterprise Manager
Microsoft SQLserver
SQLServer Group
Myhost
Databases
MYDATABASE

it displays the error:
Runtime Error occurred. Line 306
when I say debug/yes it displays a program code.|||Through My PC Desktop.|||Do you have the latest service pack installed? If you do, I would just reinstall the Client Tools. It will be a lot quicker than trying to figure this out.

Enterprise Manager question

When I click on a server node in EM, I am prompted to
enter the sa password in hte usual dialog box. However for
one particular server I get this dialog box twice - why is
this different to the others?
TIA,
BBSounds to me like something introduced by installing a security hotfix. Chan you check if that
differ on the server or client level?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c4a1a5$83884c40$a501280a@.phx.gbl...
> When I click on a server node in EM, I am prompted to
> enter the sa password in hte usual dialog box. However for
> one particular server I get this dialog box twice - why is
> this different to the others?
> TIA,
> BB

Enterprise Manager question

When I click on a server node in EM, I am prompted to
enter the sa password in hte usual dialog box. However for
one particular server I get this dialog box twice - why is
this different to the others?
TIA,
BB
Sounds to me like something introduced by installing a security hotfix. Chan you check if that
differ on the server or client level?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BB" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c4a1a5$83884c40$a501280a@.phx.gbl...
> When I click on a server node in EM, I am prompted to
> enter the sa password in hte usual dialog box. However for
> one particular server I get this dialog box twice - why is
> this different to the others?
> TIA,
> BB

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Enterprise Manager Hangs....

1. SQL Server 2K with Service Pack 3.x.

Steps to generate error in Enterprise Manager.

Right click on Database node, select All Tasks and Restore Database... Hourglass appears for ever.

All Tasks--> Backup Database... and All Tasks--> Attach Database... works fine.

Installed the SP4 and reinstalled the Enterprise Manager component. No help. Still the same hourglass at this stage.

2. When the above steps are repeated from other PC(Enterprise Manager), the hour glass appears. Irrespective from which EM (different PC) I run the above steps the EM hangs.

What would be the cause and remedy.

Thank you for your thoughts.

Smith

Here is the update on this issue...

Restore database window appears after long wait.... more than an hour.........

It never use to be so earlier.

What got changed recently?

SQL Server was writing the backup files(full backup, differential backup and transactional backup on UNC path) to Windows 2K Server and lately started writing to Windows Server 2003.

When the restore is selected it will list all the backup set files and its path. Is the EM taking longtime to read this list? Does the new file system is delaying the read?

Any thoughts?

Thank you,

|||

|||

|||

Run a trace and see what commands, statements are being executed when it hangs. That should give you more to figure out the issue.

-Sue

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.
(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.
|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:

> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for
a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> 3a.
> I
> in
>
>

Enterprise Manager Hangs

Hi,
I'm using a Windows 2003 server with SQL Server 2000 with Service Pack 3a.
When I go to enterprise manager and click on (local) under server groups,
enterprise manager hangs and once that happens, all connections (query
analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
sqlsvr.exe and then start the server again using the Service Manager. (If I
try to stop the server after ending mmc.exe, the status of the Server just
stays as "Stopping").
If I don't go to Enterprise Manager, everything works fine. Also, just in
case you're wondering, I DO NOT have tracing enabled.
I used ProcExp from www.sysinternals.com and after clicking on (local)
with enterprise manager, I get the following data:
2 new events:
\BaseNamedObjects\Crypt32LogOff
\$SERVER$MSSQLSERVER(2427)_C_READPOSTED
when i look at the threads, i get the following:
RPCRT4.DLLNdrRangeUnmarshall
msvcrt.dll!end thread
Any thoughts/suggestions would be appreciated. Thanks.(a) stop usng Enterprise Manager :-)
(b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
list...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"JB" <JB@.discussions.microsoft.com> wrote in message
news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> Hi,
> I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
3a.
> When I go to enterprise manager and click on (local) under server groups,
> enterprise manager hangs and once that happens, all connections (query
> analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> sqlsvr.exe and then start the server again using the Service Manager. (If
I
> try to stop the server after ending mmc.exe, the status of the Server just
> stays as "Stopping").
> If I don't go to Enterprise Manager, everything works fine. Also, just
in
> case you're wondering, I DO NOT have tracing enabled.
> I used ProcExp from www.sysinternals.com and after clicking on (local)
> with enterprise manager, I get the following data:
> 2 new events:
> \BaseNamedObjects\Crypt32LogOff
> \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> when i look at the threads, i get the following:
> RPCRT4.DLLNdrRangeUnmarshall
> msvcrt.dll!end thread
> Any thoughts/suggestions would be appreciated. Thanks.|||Thanks for the link and the advice... =)
Anyway, I have a few more details about the problem:
When I click on the (local) in the server groups in enterprise manager, I
hear a beep and the status bar msg is "Establishing connection to SQL Server
and Checking Windows Security".
Also, I reinstalled SQL Server 2000 Service Pack 3a but it didn't help.
"Aaron [SQL Server MVP]" wrote:
> (a) stop usng Enterprise Manager :-)
> (b) see if a post-SP3 hotfix cures it. See http://www.aspfaq.com/2160 for a
> list...
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "JB" <JB@.discussions.microsoft.com> wrote in message
> news:53BD8E18-825F-4AEA-B9ED-E6A5F383D772@.microsoft.com...
> > Hi,
> > I'm using a Windows 2003 server with SQL Server 2000 with Service Pack
> 3a.
> > When I go to enterprise manager and click on (local) under server groups,
> > enterprise manager hangs and once that happens, all connections (query
> > analyzer or web SQL connect) fails. I have to end the tasks: mmc.exe and
> > sqlsvr.exe and then start the server again using the Service Manager. (If
> I
> > try to stop the server after ending mmc.exe, the status of the Server just
> > stays as "Stopping").
> > If I don't go to Enterprise Manager, everything works fine. Also, just
> in
> > case you're wondering, I DO NOT have tracing enabled.
> >
> > I used ProcExp from www.sysinternals.com and after clicking on (local)
> > with enterprise manager, I get the following data:
> >
> > 2 new events:
> > \BaseNamedObjects\Crypt32LogOff
> > \$SERVER$MSSQLSERVER(2427)_C_READPOSTED
> >
> > when i look at the threads, i get the following:
> > RPCRT4.DLLNdrRangeUnmarshall
> > msvcrt.dll!end thread
> >
> > Any thoughts/suggestions would be appreciated. Thanks.
>
>

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.

From the Enterprise Manager when i right click on a table and select
Return all row. I am getting the below error

An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error: Unspecified error

When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent

TIA
AdilDid you start and stop EM

Why is this urgent btw?

EM is quirky...if you deleted an object it might still be referencing it...

Don't use EM to query data in the first place...|||Hi,

I didnt stop and start EM
Most of the programmer are using the EM and complaining. And non of the objects are deleted. It is happening with all the Tables
Pls help me out

Originally posted by Brett Kaiser
Did you start and stop EM

Why is this urgent btw?

EM is quirky...if you deleted an object it might still be referencing it...

Don't use EM to query data in the first place...

Enterprise Manager Error Pls Help

Hi All,
Sqlserver 7.
From the Enterprise Manager when i right click on a table
and select
Return all row. I am getting the below error
An unexpected error happened during this operation.
[Query]- Query Designer encountered a Query error:
Unspecified error
When i use Query Analyser i am able to retrive the Data
Pls help Its Urgent
TIA
HaseebIf the drive that holds the temp directory is running low on space this
error can be generated. Enterprise manager creates temporary files when it
returns all rows.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Enterprise Manager Closes

When I right click on any of our databases and select
Properties, Enterprise Manager automatically closes. It
doesn't give me an error or anything. I tried
reinstalling it but it didn't help.
Any ideas?
Jose
I've seen this only if Yukon is installed.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
When I right click on any of our databases and select
Properties, Enterprise Manager automatically closes. It
doesn't give me an error or anything. I tried
reinstalling it but it didn't help.
Any ideas?
Jose
|||I don't really know what Yukon is. How would I know if it
is installed?
Jose

>--Original Message--
>I've seen this only if Yukon is installed.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <ja@.mkrs.com> wrote in message
>news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
>When I right click on any of our databases and select
>Properties, Enterprise Manager automatically closes. It
>doesn't give me an error or anything. I tried
>reinstalling it but it didn't help.
>Any ideas?
>Jose
>
|||It is the next release of SQL Server, currently in Beta1. If you check
Programs->SQL Server, it should have a tool called SQL Server Workbench.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote in message
news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
I don't really know what Yukon is. How would I know if it
is installed?
Jose

>--Original Message--
>I've seen this only if Yukon is installed.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <ja@.mkrs.com> wrote in message
>news:d64201c410e9$25aee5e0$a001280a@.phx.gbl...
>When I right click on any of our databases and select
>Properties, Enterprise Manager automatically closes. It
>doesn't give me an error or anything. I tried
>reinstalling it but it didn't help.
>Any ideas?
>Jose
>
|||I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>
|||I'll see what I can find.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:124ef01c410f6$ec18e430$a101280a@.phx.gbl...
I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>
|||Two methods - use which is applicable:
Method 1
In your SQL Server bin directory, run:
regsvr32 sqldmo.dll
Method 2
You want to create a txt file for the dll's and run this at the command
prompt to *batch* register them.
for /f %i in (c:\dmo.txt) do regsvr32 %windir%\system32\%i /s
--c:\dmo.txt--
ODBC32.dll
odbc32gt.dll
odbc16gt.dll
ODBCCP32.dll
odbccr32.dll
odbccu32.dll
odbcint.dll
odbcp32r.dll
ODBCTL32.DLL
odbctrac.dll
SQLSRV32.dll
sqlunirl.dll
odbcbcp.dll
I'd like to thank fellow MVP's Anith, Greg and oj for the above tips.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
..
"Jose Alfaro" <ja@.mkrs.com> wrote in message
news:124ef01c410f6$ec18e430$a101280a@.phx.gbl...
I checked but I didn't find that tool. Do you have any
suggestions as to what else I can try?
Jose

>--Original Message--
>It is the next release of SQL Server, currently in
Beta1. If you check
>Programs->SQL Server, it should have a tool called SQL
Server Workbench.
>--
>Tom
>----
--
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>"Jose Alfaro" <anonymous@.discussions.microsoft.com> wrote
in message
>news:d67a01c410ec$9eb0a700$a001280a@.phx.gbl...
>I don't really know what Yukon is. How would I know if it
>is installed?
>Jose
-
>--
>