You can change the maximum output characters in Query Analyser. Query >
Current Connection Option > Select the advanced tab and edit the maximum
characters per column.

regards
David Cameron
nOw.b2b
dcameron@i...

> -----Original Message-----
> From: chris [mailto:ckevins@3...]
> Sent: Tuesday, 24 September 2002 3:17 AM
> To: sql language
> Subject: [sql_language] SQL Server Data Entry limited
> 
> 
> Hello
> 
> I have a table in my SQL Server with a column that is an 
> NVARCHAR(4000) 
> yet via SQL Server interface I can only enter 1024 characters (when i 
> right click a table and "return all rows"). Is this a bug 
> with the SQl 
> table control or am i missing something.
> 
> I can add 4000 chars via a stored procedure fine.
> 
> thanks
> .