How to Fix Inconsistent Metadata Errors

Question

How to Fix Inconsistent Metadata Errors

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

ken_opp Valued Member Points: 53 More actions · Answer 1

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".

Antares686 SSC Guru Points: 125444 More actions · Answer 2

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.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

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/[/url]

Antares686 SSC Guru Points: 125444 More actions · Answer 4

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.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

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/[/url]

phatal Newbie Points: 3 More actions · Answer 6

Thanks for identifying this issue.

1 minute to find it via google and 3 minutes to fix it is a good turn around in my book.

I agree with an earlier poster that it is probably preferable to fix this problem by renaming the old table and recreating it using 'select * into [new] from [old]' (or similar).

Edited by - phatal on 09/02/2003 12:51:24 AM

Edited by - phatal on 09/02/2003 12:52:37 AM