I am an application programmer and do not have DBA experience.
When I modified (added about 10 lines of code) a Stored Procedures (SQL 6.5) and compiled I received the following statement:
"Object text is too long - can only support 255 rows in Syscomments. Shorten the object text or split into multiple objects........ .".
Is there a way to increase the size of Syscomments system table or any trick to resolve this problem without creating a sub-Stored Procedure to reduce the size of the SP?
When I modified (added about 10 lines of code) a Stored Procedures (SQL 6.5) and compiled I received the following statement:
"Object text is too long - can only support 255 rows in Syscomments. Shorten the object text or split into multiple objects........ .".
Is there a way to increase the size of Syscomments system table or any trick to resolve this problem without creating a sub-Stored Procedure to reduce the size of the SP?