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...