This is something I have never come across...how long is your insert statement ?!
Do you copy and paste as one long line ? Have you tried breaking up your t-sql and then copying and pasting ?
If it's a replicated column that you're trying to insert into - do an exec sp_configure and look at the settings for "max text repl size" -
**ASCII stupid question, get a stupid ANSI !!!**