Windows

General discussion

Locked

Different column lenght

By greyes ·
I have a database in SQL Server 7.0 with Windows NT Server 4.0.

I changed a column length from a table using
the design table in the Sql Entreprise Manager.
But when a check this column with system tables and informatin schema views this column has different length.

Any idea in fixing this problem?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Different column lenght

by Lo In reply to Different column lenght

Hi - I don't use SQL Server but did work with a RDBMS some time back (non-Windows based). When we made such changes to metadata, to get it to work we needed to 'unload/reload' or otherwise convert data for existing entries. Not sure if it works inSQL, but in Access was to create a temp filed x<oldfield>, copy all of the existing fields into the x<oldfield>, delete/rename the <oldfield>, rename x<oldfield> as <oldfield>. Roundabout way to do it but was faster than unload/load. lo

Collapse -

Different column lenght

by greyes In reply to Different column lenght

Poster rated this answer

Collapse -

Different column lenght

by greyes In reply to Different column lenght

This question was closed by the author

Related Discussions

Related Forums