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: