Can't Add Tables To A Diagram

SQL Server 2000 - Latest SP, etc...
I can create a blank diagram for my database, but when I try to add a table
I get "Invalid Class String" - regardless of the table I try to add. I
can't find anything that addresses this issue. Anyone have an answer on how
to get past it? Thanks.
Jerry
Hi Jerry,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood when you want to create the diagram
via SQL Server Enterprise Manager, you will encounter the error message
"Invalid Class String". If I have misunderstood your concern, please feel
free to point it out.
Based on my knowledge, it seems some DLL in the SQL Server Client Tools is
corrupted. You will have to reinstall the SQL Server 2000 Client Tools and
then re-apply the Service Pack on the server.
If the reinstallation also fails, please attach the sqlstp.log and
sqlsp.log in the newsgroup for my further research. Thank you for your
patience and cooperation. If you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Can't Add Tables To A Diagram

SQL Server 2000 - Latest SP, etc...
I can create a blank diagram for my database, but when I try to add a table
I get "Invalid Class String" - regardless of the table I try to add. I
can't find anything that addresses this issue. Anyone have an answer on how
to get past it? Thanks.
JerryHi Jerry,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood when you want to create the diagram
via SQL Server Enterprise Manager, you will encounter the error message
"Invalid Class String". If I have misunderstood your concern, please feel
free to point it out.
Based on my knowledge, it seems some DLL in the SQL Server Client Tools is
corrupted. You will have to reinstall the SQL Server 2000 Client Tools and
then re-apply the Service Pack on the server.
If the reinstallation also fails, please attach the sqlstp.log and
sqlsp.log in the newsgroup for my further research. Thank you for your
patience and cooperation. If you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.sql

Can't Add Tables To A Diagram

SQL Server 2000 - Latest SP, etc...
I can create a blank diagram for my database, but when I try to add a table
I get "Invalid Class String" - regardless of the table I try to add. I
can't find anything that addresses this issue. Anyone have an answer on how
to get past it? Thanks.
JerryHi Jerry,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood when you want to create the diagram
via SQL Server Enterprise Manager, you will encounter the error message
"Invalid Class String". If I have misunderstood your concern, please feel
free to point it out.
Based on my knowledge, it seems some DLL in the SQL Server Client Tools is
corrupted. You will have to reinstall the SQL Server 2000 Client Tools and
then re-apply the Service Pack on the server.
If the reinstallation also fails, please attach the sqlstp.log and
sqlsp.log in the newsgroup for my further research. Thank you for your
patience and cooperation. If you have any questions or concerns, don't
hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

cannot select from INFORMATION_SCHEMA views

On a SQL200 server, connected as sa, I am trying to select
from the INFORMATION_SCHEMA views, but I get an error
message indicating an invalid object. However, if I use
Enterprise Manager (registered as sa) to look at the views
in the master database, I can see the views and they show
they are owned by INFORMATION_SCHEMA. I've verified that
the public group has SELECT permissions to the views. Any
ideas, anyone?Sean Hokanson (shokanson@.sandlot.com) writes:
> On a SQL200 server, connected as sa, I am trying to select
> from the INFORMATION_SCHEMA views, but I get an error
> message indicating an invalid object. However, if I use
> Enterprise Manager (registered as sa) to look at the views
> in the master database, I can see the views and they show
> they are owned by INFORMATION_SCHEMA. I've verified that
> the public group has SELECT permissions to the views. Any
> ideas, anyone?
What exact statement are you using?
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||Sean Hokanson (shokanson@.sandlot.com) writes:
>>What exact statement are you using?
> select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE
That seems to work here. What exact error message do you get?
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Cannot Run Replication Setup From EM in SQL server 2000 EE

When we try to run the Configure Publishers, Subscribers, and Distribution
from the EM Wizrd, we get the Error 208 invalid Object
msdb.dbo.MSDitsributiondbs and the setup quits. The server is a Cluster,
with Log Shipping. Select @.@.Servername returns the correct server name. The
interesting thing is that we have three other servers with the same
configuration that are working just fine.Any ideas? Thanks.
Is this table present in msdb?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:uNhWwMi$FHA.912@.TK2MSFTNGP11.phx.gbl...
> When we try to run the Configure Publishers, Subscribers, and Distribution
> from the EM Wizrd, we get the Error 208 invalid Object
> msdb.dbo.MSDitsributiondbs and the setup quits. The server is a Cluster,
> with Log Shipping. Select @.@.Servername returns the correct server name.
> The
> interesting thing is that we have three other servers with the same
> configuration that are working just fine.Any ideas? Thanks.
>
|||No the table is not. I see the table in the stand alone servers that we have
Transactional Replication running on but not on the SQL Server 2000 Clusters
which are also running replication. This is the puzzle for us. By the way
good book you put out Hilary. Do you plan one for SQL 2005? if so please
hurry up!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ev75WZl$FHA.2156@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Is this table present in msdb?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
> news:uNhWwMi$FHA.912@.TK2MSFTNGP11.phx.gbl...
Distribution
>
|||There is something very wrong with the latest sp upgrade. Please reapply it.
I have to push out the SQL 2000 merge volume before 2005.
I am working on some tutorials for SQL 2005 replication for sswug.com.
I think I knew you from swynk.com in one of the nt groups.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:u3KclHp$FHA.1600@.TK2MSFTNGP11.phx.gbl...
> No the table is not. I see the table in the stand alone servers that we
> have
> Transactional Replication running on but not on the SQL Server 2000
> Clusters
> which are also running replication. This is the puzzle for us. By the way
> good book you put out Hilary. Do you plan one for SQL 2005? if so please
> hurry up!
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ev75WZl$FHA.2156@.TK2MSFTNGP11.phx.gbl...
> Distribution
>
|||The server is SP4 on Win2k Adv Svr. Are you suggesting re-applying the SP4?
Becuase that is the revision level that it is at now. It is a production
server with clusterign and log shipping on it already. So we are beign
cautious here. I remember you too from the early Stven Wynkoop Days. It dont
visit as often as it has taken a different tone as a site. Just an old DBA
here.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OYrMgxy$FHA.3852@.TK2MSFTNGP14.phx.gbl...
> There is something very wrong with the latest sp upgrade. Please reapply
it.[vbcol=seagreen]
> I have to push out the SQL 2000 merge volume before 2005.
> I am working on some tutorials for SQL 2005 replication for sswug.com.
> I think I knew you from swynk.com in one of the nt groups.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
> news:u3KclHp$FHA.1600@.TK2MSFTNGP11.phx.gbl...
way[vbcol=seagreen]
name.
>
|||I am looking for information from others that may have run into issues with
SP4 and SQL Server 2000 Replication. I am suspicious that this may have been
the culprit in my inablility to configure publishing on one of my servers.
Please share you knowledge on this one. Thanks.
"Patrick Ikhifa" <patisi@.pacbell.net> wrote in message
news:uIY$sg6$FHA.2736@.TK2MSFTNGP11.phx.gbl...
> The server is SP4 on Win2k Adv Svr. Are you suggesting re-applying the
SP4?
> Becuase that is the revision level that it is at now. It is a production
> server with clusterign and log shipping on it already. So we are beign
> cautious here. I remember you too from the early Stven Wynkoop Days. It
dont[vbcol=seagreen]
> visit as often as it has taken a different tone as a site. Just an old DBA
> here.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OYrMgxy$FHA.3852@.TK2MSFTNGP14.phx.gbl...
> it.
we[vbcol=seagreen]
> way
please
> name.
>