Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

How to Fix Inconsistent Metadata Errors Expand / Collapse
Author
Message
Posted Tuesday, February 11, 2003 5:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 23, 2005 12:40 AM
Points: 174, Visits: 1
I was woking in a reply of my real BBDD.

Thank's...

i have find the solution running instcat.SQL
from install dir.








Post #28721
Posted Thursday, February 13, 2003 3:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 14, 2013 3:40 PM
Points: 12, Visits: 33
A new twist......
2 servers running SQL7 SP3 and getting this error from a single table. I've manually check the ordinal numbers - they are identical and sequential... there should be no problem? There is, it still gives Msg 7353...

I have no explanation, I got round it by locally copying the data I needed into a new table and then querying that.




dgm
Post #28722
Posted Friday, March 28, 2003 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 16, 2004 12:06 PM
Points: 6, Visits: 1
I can't thank you enough!!! You saved our production run from being late! I ran this on SQL Server 7 sp 4 and it worked like a charm.




Post #28723
Posted Friday, August 15, 2003 9:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 26, 2011 1:37 PM
Points: 3, Visits: 6
Excellent solution. Took me 2 hours to find this article and then 5 more minutes to fix my problem.




Post #28724
Posted Friday, August 22, 2003 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 26, 2011 1:37 PM
Points: 3, Visits: 6
At first I thought this worked, but further testing revealed that is corrupted the table. I have two 7.0 SP3 servers and after running sp_fixColOrder, I was able to read my table remotely. However, when I do a simple table join, I got this error:

Cannot insert the value NULL into column '', table ''; column does not allow nulls. INSERT fails.

Now this error message (like most) did not make any sense because I'm doing a simple select and join (no update) yet getting an error indicating that an "insert fails".

Next I tried an sp_help on my table on received many errors. Here are a few:

Cannot insert the value NULL into column 'index_keys', table 'tempdb.dbo.#spindtab_

Cannot insert the value NULL into column 'cnst_type', table 'tempdb.dbo.#spcnsttab

I am sure it is the sp_fixColOrder that caused the error, because I recreated the database from a backup and ran my "join query" before and after running sp_fixColOrder.

Perhaps the problem is caused by my indexes, default constraints, and/or an identity column.






Post #28725
Posted Friday, August 22, 2003 6:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 26, 2011 1:37 PM
Points: 3, Visits: 6
Again, two 7.0 SP3 databases both with MDAC 2.7.

After removing all indexes, constraints, and even SQL statistics I still got errors when I ran sp_fixColOrder.

So my final solution was to rename the table (sp_rename obj, obj_new), create a new table from scratch, and run an "insert into obj select * from obj_old".





Post #28726
Posted Saturday, August 23, 2003 10:09 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Friday, September 26, 2014 11:48 AM
Points: 8,370, Visits: 742
Sorry Ken I have been out with a new baby and not doing much of anything. I have found did run across a reason why my solution will not fix all cases but forgot where I put my notes. I would avoid it at this point and consider going to SP4 which fixed all the test issues I could create. I am still out so responses will be slim.




Post #28727
Posted Monday, August 25, 2003 12:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
Hi James,
quote:

Sorry Ken I have been out with a new baby and not doing much of anything.

is this some tricky sort of slang or does it mean what it reads

Just asking, before I congrat you to something completely different and make even more a fool out of me.

Cheers,
Frank


--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #28728
Posted Monday, August 25, 2003 3:39 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: Moderators
Last Login: Friday, September 26, 2014 11:48 AM
Points: 8,370, Visits: 742
Thanks, it means what it means. Sleepless nights, lots of crying, dirty diapers and feeding all the time. But I can't complain I am just the father, mom has it worse than me.




Post #28729
Posted Monday, August 25, 2003 4:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:18 AM
Points: 5,956, Visits: 285
Hey, let me explicitely say:

Congratulations to your newborn baby

I hope all are well ?!?

In case this is your first child, it might help you, that in max three years you'll laugh over your situation now. Somehow it turns into something sentimental glorified

Take care!

Cheers,
Frank


Here's a sproc written for me by David Burrows


DROP Dirty_Nappy
GO
SELECT Clean_Nappy FROM Nappy_Pile WHERE COUNT(Clean_Nappy) > 0
INSERT Baby INTO Clean_Nappy
GRANT ALL Smiles to Baby
GO


Edited by - Frank Kalis on 08/25/2003 04:31:32 AM

Edited by - Frank Kalis on 08/25/2003 04:32:11 AM


--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/
Post #28730
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse