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

"phil2phil" <philtwophil@yahoo.com> wrote in message
news:1173714656.510142.22770@v33g2000cwv.googlegroups.com...
> hi,
> i have a column of type ntext in the db, we're using that to allow
> users to store essays they can enter. problem is when i'm running a
> select on the ntext column, data seems to be getting cut off, isn't
> ntext suppose to hold a lot of data, we wanted to allow them in a min
> of 1500 chars, while everytime i do a
> select len(max (convert(nvarchar(2000), essaytext)))
>
> just to see the max we one had it's always 200.
>
> Thanks.
>

What tool are you using for this? If it's QA, you can adjust what it returns
via a setting.

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

• Next in forum: Trying to add a NON-DISTINCT field to a DISTINCT record set in a query.
• Prev in forum: Re: Identity reused problem
• Thread view: Re: pulling ntext values sql server 2005

[Reply to this message]