Posted by Greg D. Moore \(Strider\) on 03/12/07 17:51

"phil2phil" <philtwophil@yahoo.com> wrote in message
news:1173717649.377685.103280@h3g2000cwc.googlegroups.com...
>I think i found it, the stored proc doing the actual insert into the
> table, was set to @ESSAYTEXT varchar(200) for that column, we decided
> to restrict it to 2000 chars, so changing it to @ESSAYTEXT
> varchar(2000), hopefully that's fix it, the varchar(200) explains the
> max(len issue as well.
>

Yeah.. if you're only inserting 200.. ;-)

(note that text fields sometimes are better handled with readtext/writetext.

But if you're moving to SQL 2005 any time I'd highly recommend varchar(max)



--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

[Back to original message]