Windows Forum

Ask something
Discussion Locked

Different column lenght

0 helpful
3 replies

by greyes 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

3 replies

by lo

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, copy all of the existing fields into the x, delete/rename the , rename x as . Roundabout way to do it but was faster than unload/load. lo

This discussion is closed to new replies.