Cannot create a row of size
Posted on 2009-04-22
Good afternoon expert,
Needed to get a copy of stored procedures to search for a string. My old DBA buddy
select o.name, c.text from sysobjects o inner join syscomments c on o.id = c.id where c.text like '%searched_for_string%';
Was going to save a copy of the table with
select o.name, c.text
from sysobjects o inner join syscomments c on o.id = c.id where c.text like '%select%';
When I tried this I got
Cannot create a row of size 8075 which is greater than the allowable maximum of 8060.
The statement has been terminated.
Is there a way of getting arounf this?