Alter table limitations with OLE DB and Microsoft SQL Server

When you connect using OLE DB and change the name or width of a column in an MSS2000 database using Alter Table in the Database painter in DataWindow Designer, the column is moved to the end of the table and all its data is lost. To prevent this from occurring, DataWindow Designer does not allow you to alter a table's column name and column size. You can alter the table outside the painter using ISQL scripts. [CR 348581]