paste problem for varchar(8000) | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

paste problem for varchar(8000)

i’m having a weird problem regarding pasting into a field defined as varchar(8000) i simply copied a chunk of text (abt say 2-3000 chars) and tried pasting into the field for server mgr, BUT the whole chunk just won’t go in, the text keeps getting truncated after abt 1000+ chars and i am not even able to type any extra into the field. [?][?][?] anyone of you encountered this problem? how do i rectify this problem?
I believe you’re trying this from Enterprise Manager and I suggest not to do so, if you want to transfer the data between the fields better use TSQL using QA its faster and reliable. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.