Adding VARCHAR(MAX) Columns

[JefferyD]

When adding a column to an existing table and selecting either the "varchar(max)" or "nvarchar(max)" option, I am unable to insert anything into those columns. When I checked the size of the columns in a query, the sizes came back as 1 even though the database maintenance page shows "max".

Selecting "varchar" or "nvarchar" and manually adding "max" as the max length seems to work correctly, but I only tested that when creating a new table and not when adding a column to an existing table.

[SumanPrasad]

This bug is already part of a task 10080 which is being tested. We will update this post this task is available in general release.

[JustinVanRegenmorter]

This issue has been resolved as of DesignTime Revision 2220.