How to Fix Inconsistent Metadata Errors

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by James Travis » How to Fix Inconsistent Metadata Errors

21 posts, Page 2 of 3

««1 2 3 »»

How to Fix Inconsistent Metadata Errors

Rate Topic

Display Mode

Topic Options

Author

Message

fastorro

Posted Tuesday, February 11, 2003 5:09 AM

SSC-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

dgm

Posted Thursday, February 13, 2003 3:28 AM

Grasshopper

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

crutherfurd

Posted Friday, March 28, 2003 11:19 AM

Forum 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

ken_opp

Posted Friday, August 15, 2003 9:02 AM

Forum 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

ken_opp

Posted Friday, August 22, 2003 9:21 AM

Forum 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

ken_opp

Posted Friday, August 22, 2003 6:14 PM

Forum 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

Antares686

Posted Saturday, August 23, 2003 10:09 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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

Frank Kalis

Posted Monday, August 25, 2003 12:40 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:10 AM
Points: 5,955, Visits: 272

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

Antares686

Posted Monday, August 25, 2003 3:39 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

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

Frank Kalis

Posted Monday, August 25, 2003 4:26 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, May 17, 2013 8:10 AM
Points: 5,955, Visits: 272

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 »

21 posts, Page 2 of 3

««1 2 3 »»

Permissions