Error with text data type

I have a table with a text data type field, when I paste text less than 1024
in lenght, all is right, but when the size is greater than 1024 nothing is
pasted. Some help?"Paste" where? Have you considered using an INSERT or UPDATE statement in
Query Analyzer?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?|||Hi,
Execute the command Select @.@.textsize to identify the current value.
Increase the value of store using
SET TEXTSIZE <Value in bytes>
Increase to a higher value and try inserting.
Thanks
Hari
MCDBA
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?