You've hit the SQL 6.5 hard limit of 64k bytes in a stored procedure. (this limit became about 250mb with the introduction of SQL 7.0). This is 255 bytes of SP text * 255 rows in syscomments.

Your only real options are to streamline your SP, or break it down into functional (and reusable?) components.

Your boss won't be happy I'm afraid.

Another option is break down the SP into numbered procedures with the same name:

CREATE PROCEDURE MyProc;1

.

.

GO

CREATE PROCEDURE MyProc;2

.

.

GO

etc etc