SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to Fix Inconsistent Metadata Errors


How to Fix Inconsistent Metadata Errors

Author
Message
Antares686
Antares686
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: Moderators
Points: 33418 Visits: 803
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/jtravis/changingcolumn.asp



darren.green
darren.green
SSC Veteran
SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)SSC Veteran (201 reputation)

Group: General Forum Members
Points: 201 Visits: 1
Is this not covered by this fix-

FIX: Error Message 7355 "..Inconsistent metadata for a column" Occurs When You Use a Linked Server (Q306401)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306401

Darren Green
SQLDTS.com | SQLIS.com | Konesans Ltd
Antares686
Antares686
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: Moderators
Points: 33418 Visits: 803
Actually no, the server I tested from was (RC, SP1, SP2) on 2000 and (RC, SP1, SP2, SP3) with SQL 7. The problem actually steams form the column order stored in the syscolumns table and not the string lenght compared to the index which was directly related to SQL 2000 and not 7.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)



Argyle
Argyle
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 1
This is so unbelievably on target. I had this exact same problem and MS had no fix for it. THX!!!



Antares686
Antares686
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: Moderators
Points: 33418 Visits: 803
Thank you, and as for an update, when I was doing SP4 beta it looked like the had casually fixed it there with no mention which is not unusual. However, I have not had a chance to verify with the final release code but will in the next week or so.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)



rithomas
rithomas
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 1
If you're worried about changing system columns, a quick workaround to query a linked database would be to query against views instead of tables.



thotakura
thotakura
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 3
I ran the script given by James Travis to fix the column
order . It did fix the column order, but the data in the
table got messed up as the colid and colorder columns are updated in
the syscolumns table.

Can anybody explain the reason why the data gets messed up
as the colid and colorder are updated.

Any help is appreciated and can email to sridhar_t @hotmail.com


Thanks

Sridhar



Antares686
Antares686
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: Moderators
Points: 33418 Visits: 803
I am not sure why you had this occur. I tested on several machines to insure that I was messing with the proper fields and had no issues with it in any situation I could come up with. What is visually happening to your data and can you post your table structure as I am curious specifically where this becomes an issue to try and improve it. Also, I hope you made a backup of your data beforehand as I would hate to think you lost anything but I did state I make no guarantees as there is always the unknown factor to think about. If you did you may want to restore and try updating the server to SP4 and see if this fixes (please do on a test server to test), when doing the beta it seemed it has a hushed fix of this problem which probably showed other related situations as well. Also was the version an English version server?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)



fastorro
fastorro
SSC-Enthusiastic
SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)SSC-Enthusiastic (194 reputation)

Group: General Forum Members
Points: 194 Visits: 1
NOOOOOOOOOOOOOOOOOOOO!!!

my data base has been corrupt due to this solution, This solution DOES NOT WORK with SQL server 7 SP3



Antares686
Antares686
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: Moderators
Points: 33418 Visits: 803
I do hope you made a backup.

I did check I still have not had issues so I am wondering what specifically is under the hood that causes this. Can you post your DDL so I can have a look under SQL at what it is doing?

As seems to not cause further issues in SP4 I did not test any SP4 machines. I will have the code pulled so no one else can potentially even try this.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search