Running dbcc checkcatalog

Adaptive Server has been enhanced to validate the row and column length in database tables, using information stored within the system catalogs in that database. Any discrepancy is reported in the error log with this message:

Invalid column length: <length>. Value must be between 0 and <max col length> for '<row type>' row with minimum row length of <min row length>.

This check requires accurate information within the system catalogs. If you have upgraded from an earlier version of Adaptive Server, verify that the information within the system catalogs is correct by running the dbcc checkcatalog on all databases after you have run the upgrade process, but before any database activity occurs.

Run dbcc checkcatalog(<database name>). If any errors are reported, fix them by running dbcc checkcatalog(<database name>, "fixall").

Dump the database after the fixes have been made.