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.

3 total posts (Page 1 of 1)  
| 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

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums