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