Cannot create a row of size

Posted on 2009-04-22
Last Modified: 2012-05-06
Good afternoon expert,

Needed to get a copy of stored procedures to search for a string. My old DBA buddy
select, c.text from sysobjects o inner join syscomments c on = where c.text like '%searched_for_string%';

Was going to save a copy of the table with

select, c.text
into New_SP_table_090422
from sysobjects o inner join syscomments c on = 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?


Question by:9apit
    LVL 22

    Accepted Solution



    CREATE TABLE New_SP_table_090422 ([name] varchar(128), [text] text)

    INSERT INTO New_SP_table_090422
    select, c.text
    from sysobjects o inner join syscomments c on = where c.text like '%select%';


    Author Closing Comment

    Well done. Works great.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now