Tonight I went in to add a column to one of my sql databases using GoDaddy’s SQL Server Web Admin. This column happened to be a VarChar(Max). Now when adding a varchar column, you have to enter an integer in the length column, so there is a VarCharMax field type. Unfortunately, it doesn’t work. Instead of creating a VarChar with Max as the length, it leaves it with a length of 1. The solution is to change the column type via the Query Analyzer. If you find yourself in this situation, run this query to update your column:
ALTER TABLE MyTable ALTER COLUMN MyColumn VarChar(MAX)
Happy SQLing.
