Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!

enterprise manager error

when launching the enterprise manager software, I'm getting the following message "title microsoft sql-dmo, error 126 : genral error". I could not find informations onthis error in the help. does someo,ne have an idea?
Hi,
You may need to re-register the SQL DMO dlls. Verify the below link:-
http://support.microsoft.com/?id=248241
Thanks
Hari
MCDBA
"erwan" <anonymous@.discussions.microsoft.com> wrote in message
news:7D9E5861-233F-4850-A7F2-888FB017E8E3@.microsoft.com...
> when launching the enterprise manager software, I'm getting the following
message "title microsoft sql-dmo, error 126 : genral error". I could not
find informations onthis error in the help. does someo,ne have an idea?
|||thanks hari I've fixed the problem

enterprise manager error

when launching the enterprise manager software, I'm getting the following me
ssage "title microsoft sql-dmo, error 126 : genral error". I could not find
informations onthis error in the help. does someo,ne have an idea?Hi,
You may need to re-register the SQL DMO dlls. Verify the below link:-
http://support.microsoft.com/?id=248241
Thanks
Hari
MCDBA
"erwan" <anonymous@.discussions.microsoft.com> wrote in message
news:7D9E5861-233F-4850-A7F2-888FB017E8E3@.microsoft.com...
> when launching the enterprise manager software, I'm getting the following
message "title microsoft sql-dmo, error 126 : genral error". I could not
find informations onthis error in the help. does someo,ne have an idea?|||thanks hari I've fixed the problem

enterprise manager error

when launching the enterprise manager software, I'm getting the following message "title microsoft sql-dmo, error 126 : genral error". I could not find informations onthis error in the help. does someo,ne have an idea?Hi,
You may need to re-register the SQL DMO dlls. Verify the below link:-
http://support.microsoft.com/?id=248241
Thanks
Hari
MCDBA
"erwan" <anonymous@.discussions.microsoft.com> wrote in message
news:7D9E5861-233F-4850-A7F2-888FB017E8E3@.microsoft.com...
> when launching the enterprise manager software, I'm getting the following
message "title microsoft sql-dmo, error 126 : genral error". I could not
find informations onthis error in the help. does someo,ne have an idea?|||thanks hari I've fixed the problem

enterprise manager (or other software) to document tables and columns for Server2k?

Hi,

We have enterprise manager for sql server 2000. I would like to store
comments about my database schema somewhere in the database. I want to
store information about the intent of tables and columns.

We have EM but I am open to any suggestions regarding products.metaperl (metaperl@.gmail.com) writes:
> We have enterprise manager for sql server 2000. I would like to store
> comments about my database schema somewhere in the database. I want to
> store information about the intent of tables and columns.
> We have EM but I am open to any suggestions regarding products.

You can use extended properites to this end, and that will inded put
data about the database into the database itself.

For more heavy-duty tools for data modelling, the three biggest tools
on that market are, I believe, PowerDesigner (from Sybase), ERWin
(from Computer Associates) and Embrocadero. These tools comes with a
price tag, though.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Enterprise Manager

Hi,

I need to reinstall Enterprise manager from my original CD of Microsoft SQL Server 2000.

Could you said in which folder on CD the software is placed ?

Thanks.It wouldn't necessarily matter what folder the Enterprise Manager is in since you'd most likely have to run the setup application anyway. You can choose to only install the Enterprise Manager in the dialogs.