Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old October 6th, 2003, 10:47 AM
thomadma thomadma is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Oct 2003
Location: Toronto
Posts: 5 thomadma User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Error Saving Database Diagrams

Hi,

I was wondering if there were other people that had experienced the same problem as we are presently experiencing. I was trying to save a database diagram on one of our development servers, when a pop-up window appeared stating that ad hoc reports to system catalogs were not enabled. I tested this with other db's on the server creating diagrams and I did so successfully. That leads me to believe that this is not the issue. Finally, we recently migrated to sql server 2000 from sql server 7.0 and while doing a restore of this database, I received the following errors:

Invalid column name 'excluded_cols'. [SQLSTATE 42S22] (Error 207) Invalid column name 'excluded_col_count'.
[SQLSTATE 42S22] (Error 207) Invalid column name 'vertical_partition'. [SQLSTATE 42S22] (Error 207)
Invalid column name 'identity_support'. [SQLSTATE 42S22] (Error 207) Invalid column name 'destination_owner'.
[SQLSTATE 42S22] (Error 207) Invalid column name 'verify_resolver_signature'. [SQLSTATE 42S22] (Error 207)
Invalid column name 'allow_interactive_resolver'. [SQLSTATE 42S22] (Error 207)
Invalid column name 'fast_multicol_updateproc'. [SQLSTATE 42S22] (Error 207)
Invalid column name 'check_permissions'. [SQLSTATE 42S22] (Error 207)
Could not adjust the replication state of database 'FordDB'. Could not adjust the replication state of database 'FordDB'. The database was successfully
restored, however its replication state is indete...

Does anyone know how I can turn off the replication state of a database and if this is what's causing the problem?

Thanks,

Maria

Reply With Quote
  #2  
Old October 8th, 2003, 05:49 AM
m_lazor m_lazor is offline
Contributing User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Sep 2003
Location: Luxembourg
Posts: 156 m_lazor User rank is Corporal (100 - 500 Reputation Level)m_lazor User rank is Corporal (100 - 500 Reputation Level)m_lazor User rank is Corporal (100 - 500 Reputation Level)m_lazor User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Looks like this database participated in replication. check out these links they may be helpful:

65.61.175.198/archives/t307628.html

dbforums.com/t390383.html

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft SQL Server > Error Saving Database Diagrams


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT