


A-MSSQL-MAX-COLUMNS indicates the maximum number of columns the Acu4GL product will allow in a table. The default value is 250.
Microsoft SQL Server places a limit on the number of columns per table. The Acu4GL product will adhere to this limit, but sometimes it cannot accurately count how many columns a table contains (because a column has been added to a table without the Acu4GL product's knowledge). This variable enables the developer to set the Acu4GL product's upper bound. You might want to try reducing the upper bound if you discover that a table cannot be created for some reason. By reducing the upper bound, you allow for uncountable columns and thus may be able to prevent the problem.
If SQL Server increases the maximum number of columns allowed per table (in a future release of the product), you could increase the value of this variable to take advantage of the new limit. Consult your SQL Server documentation to decide the new maximum number of columns allowed per table.