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 log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
Don
Hi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
DonHi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>

Enterprise log in issue

I am using SQL 2000 developer edition and all has been
working fine, until today. In Entrprise manager I can
not log into my local database however I can log into a
remote one. Additionally my local development
applications can access data and function fine they all
use SQL server authentaction.
In enterprise manager whenI try to log in I get the
following message-
Log In Filed for user "name"
please verify your SQL Server is running and check ....
I am sure you all get the idea.
I have tried everything and changed nothing, particularly
any passwords.
Any ideas?
DonHi,
Can you try re-registering the Enterprise manager using SQl Authentication
and try connecting. You could
also try connecting to sql server using Query Analyzer.
Since you are able to connect to the application which is accessing the same
sql server , I hope
there will not be any major issue. Still verify the sql server error logs in
\sql server prgram directory\log
Thanks
Hari
MCDBA
"Don Stull" <dstull1@.msn.com> wrote in message
news:OjUiIXMeEHA.2908@.TK2MSFTNGP10.phx.gbl...
> I am using SQL 2000 developer edition and all has been
> working fine, until today. In Entrprise manager I can
> not log into my local database however I can log into a
> remote one. Additionally my local development
> applications can access data and function fine they all
> use SQL server authentaction.
> In enterprise manager whenI try to log in I get the
> following message-
> Log In Filed for user "name"
> please verify your SQL Server is running and check ....
> I am sure you all get the idea.
> I have tried everything and changed nothing, particularly
> any passwords.
> Any ideas?
> Don
>