Enterprise Manager

I went to Enterprise Manager to examine database
table ... Highlightlighted desired table, right
clicked ... went to Open Table / Return All Rows,
clicked ... received an error [Unknown error: 800700F]
I have cleaned up database, re-installed software several
times ... only to arrive at the same result.
Note: MS SQL is running as Local
Please advice ... I have examined rights as well!
Ellie
What happens if execute this from Query Analyzer?
(you will have to replace dbname, owner, and table so that it works in your
environment)
SELECT * FROM [dbname].[owner].[table]
If it works, the problem is probably isolated to Enterprise Manager.
I found an answer posted by Baisong Wei that might solve the problem:
=============================
From my experience, if you meets error 800700f, you could download the SQL
Server SP3 and the latest MDAC, then reboot you computer.
You could download them at:
Microsoft SQL Server 2000 Service Pack 3a
http://www.microsoft.com/downloads/d...DisplayLang=en
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/d...DisplayLang=en
Hope this helps. If you still have question, please feel free to post
message here and I am ready to help. Thanks.
Best regards
Baisong Wei
Microsoft Online Support
=============================
Keith
"Ellie" <ellie@.emsplus.net> wrote in message
news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
> I went to Enterprise Manager to examine database
> table ... Highlightlighted desired table, right
> clicked ... went to Open Table / Return All Rows,
> clicked ... received an error [Unknown error: 800700F]
> I have cleaned up database, re-installed software several
> times ... only to arrive at the same result.
> Note: MS SQL is running as Local
> Please advice ... I have examined rights as well!
> Ellie
|||These may be helpful as well:
http://groups.google.com/groups?hl=e...ic.sqlserver.*
http://groups.google.com/groups?q=%2...x.gb l&rnum=1
Keith
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:eXtiIxpaEHA.3480@.TK2MSFTNGP11.phx.gbl...
> What happens if execute this from Query Analyzer?
> (you will have to replace dbname, owner, and table so that it works in
your
> environment)
> SELECT * FROM [dbname].[owner].[table]
> If it works, the problem is probably isolated to Enterprise Manager.
>
> I found an answer posted by Baisong Wei that might solve the problem:
> =============================
> From my experience, if you meets error 800700f, you could download the SQL
> Server SP3 and the latest MDAC, then reboot you computer.
> You could download them at:
> Microsoft SQL Server 2000 Service Pack 3a
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Microsoft Data Access Components (MDAC) 2.8
>
http://www.microsoft.com/downloads/d...DisplayLang=en
> Hope this helps. If you still have question, please feel free to post
> message here and I am ready to help. Thanks.
> Best regards
> Baisong Wei
> Microsoft Online Support
> =============================
> --
> Keith
>
> "Ellie" <ellie@.emsplus.net> wrote in message
> news:2d04701c46a96$2140ccb0$a601280a@.phx.gbl...
>
|||Keith:
Thanks, I found that installing the SP3 resolved the problem and I did
notice it updated MDAC as well.
Your time is most appreciated.
Ellie Warther
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!