>>>Thanks Boris!
>>>
>>>If you were to store the text template in SQL Server, what field type would you use?
>>
>>Either varchar(max) or XML
>
>Thanks, I had chosen nvarchar(MAX), would that make a difference?
If you want to use unicode data (non English letters), then you need to use unicode (nvarchar). So, it's OK choice.
If it's not broken, fix it until it is.
My Blog