Hi, I have a made a full text index on column in a table having only 2 cols in all(one phrase(varchar(4000)) and second Id). Now i want to change that col to varchar(max). Query 1: How will it affect my FTS(if at all it'll affect)? Query 2: Any drawbacks of using varchar(max) cols apart from that it stores the data off-row incase the row size goes beyond 8060 bytes?
I don't see any reasons or reference on web that you may have problems, but http://msdn.microsoft.com/en-us/library/ms142560.aspx is worth visiting.