>Greg, in SQL 2005, MS lifted the 8K limit on varchars, nvarchars, varbinary, etc.
>
>So you can have a VARCHAR(MAX), VARBINARY(MAX)....I forget the limit, but it's some astronomical limit...
2GB limit. (so 1GB for nvarchar).
If it's not broken, fix it until it is.
My Blog