Is there a way out to the following error:
Server: Msg 511, Level 16, State 1, Line 1
Cannot create a row of size 8247 which is greater than the allowable maximum of 8060.
The statement has been terminated.
I get the above error when i try to insert sql with a large string. Is there any other way out or i have to break my query into smaller parts?