Hai,
    I’ve to store the contents in word/text documents along with the format in SQL Server table field. The document may be upto 3MB. But, the length of varbinary and varchar fields in SQL Server can be of 8000 at the max.
Any suggestions….Please welcome.

-Priya

Hi , U can use text or ntext datatype.It doesnt have max limit

Hi,

text and ntext types do not store unlimited data. text can go roughly up to 2GB and ntext upto 1GB.

As SriRamaKrishna pointed out, text and ntext both data types would fill the purpose. However, logically they are used to store textual data of huge size. When storing such things as Word documents or images (read binary data), it's best to use the image data type. image can store binary data of roughly up to 2GB.

For binary data of small size, using binary or varbinary (both roughly up to 8KB) is much more efficient.

Cheers.

ejan