Do you really need
ntext
? It can really be a pain... If 4000 characters is enough for you in the field, then I suggest that you use
nvarchar
instead.
Another point. Your post sounds like the unique identifier is some kind of custom identifier and it actually has a meaning. If it is some kind of concatenation from data, I'd suggest that you would use real unique identifiers instead => keys that are unique but the data doesn't have a meaning, the only purpose is that it's unique. For more info see:
http://msdn.microsoft.com/en-us/library/ms187942.aspx[
^]