Solution for storing Long Text
Hai
Try to declare the Data type as "CLOB". It will store 1 Billion upto Characters.
A character large object (CLOB) is a text,ntext, or image in SQL parlando
A character large object (CLOB) is a text,ntext, or image in SQL parlando. So SQLServer does support CLOB it is called text (for 8 bit ascci) or ntext (for 16 bit unicode). It can store up to 2 Gigabyte of information which is 2,147,483,647 ascci characters or 1,073,741,823 unicode characters. If you'd like to store binary data there is the image type which stores up to 2,147,483,647 bytes.
hope this helps