May 15, 2003 at 11:21 am
I have 1 row in a table that does not seem to accept data of appropriate form char(10). If I copy data from a healthy row - in the RETURN ALL ROWS view in EM - I get an error that says the data in the column is wrong type/length. Yet if I copy the same data into any other row - there is no error. Is the table/db corrupted? what can I do to fix?
thx.
May 15, 2003 at 12:02 pm
When you paste data into the cell, be sure to clear all other data out of it before you paste. There may be spaces in the cell before you try pasting the data, which would produce this error...
May 15, 2003 at 12:13 pm
THX - I have checked this ... there's no extra spaces or anythnig.. and the exact same steps in another row - does not raise an error?
quote:
When you paste data into the cell, be sure to clear all other data out of it before you paste. There may be spaces in the cell before you try pasting the data, which would produce this error...
May 15, 2003 at 12:33 pm
MAybe you should try with a select statement with query analizer. If also returns an error you can check the table consistency with dbcc checktable.
May 15, 2003 at 2:57 pm
Depends on the number of rows but copy table into another table, like tableTMP, truncate or (drop old,recreate,table,indexes) and copy data back. Maybe run checkdb before repopulating
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply