SQL 6.5 datatype "text"?greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I canīt upload data from a .txt file via bcp, all the columns are complete but the text column which is a datatype 'text' is truncated, it only holds 255 bytes, what should I do to increase de text size?
-- Anonymous, November 01, 2001
The data may actually be importing but you can only see the first 256 characters in ISQL/w or the Query Analyzer. Test it by bcp'ing out the data and looking at the text column data.
Hope this helps,
-- Anonymous, November 02, 2001