i'm currently getting an error updating a large text field in my sql server database the error is:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC SQL Server Driver]String data, right truncation
/adm/includes/object_data.asp, line 220
thie error line coincides with my stored procedure being executed. this worked fine when the field was a varchar datatype but now it is a text datatype (i need this size) it doesn't work. can anyone please help...