MS SQL Field Length Limits

[CoolCoder]

Does anyone know how to increase the field length limit to hold more than 8000 characters.
I currently use Access's "Memo" field type which seems to work fine but I need to upgrade to MS SQL.
I have huge text files and as it is MS SQL can't do it.
HELP!

Tony

 

[JamesLean]

You need to use the text data type in SQL Server. You cannot increase the max length of varchar type. --James

 

[JohnDTampaBay]

CoolCoder -

Please note that the text datatype requires special handling. Check out BOL for READTEXT and WRITETEXT commands. Good luck! --Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.