Hi,

I got this error, msg no 2735

Object text is too long - can only support 255 rows in Syscomments. Shorten the object text or split into multiple objects. Text which caused overflow starts at: '%.*s'.

what is the solution for this error.

Thanks, Ravi.

-- Anonymous, January 22, 2002

Answers

Ravi,

You don't say what version of SQL Server you are using, but I recall that some versions previous to SQL Server 2000 have a limit of around 65,000 characters. You might try breaking the stored procedure up into more than one stored procedure.

Also, one poster on usenet found: "It turns out it is a bug in the ISQL/W GUI. I had to create the procedure through the ISQL command line, and it worked OK."

Hope this helps,

Eric

-- Anonymous, January 22, 2002