How can I tell if an index contains a column of type varchar(max)?

If you have a char or nvarchar with a max length, then it will have an entry in the sys. Columns table with the appropriate system type id for the field, with -1 as the max length.

I think that for "max" columns, the length or size feild in the sys. Columns table should be -1. Don't have the documentation in front of me, but let me know if this works.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.