> I am already doing the naming convention method.
> Currently I have SP under names like TABLE_NAME_S, TABLE_NAME_I,

TABLE_NAME_U, and TABLE_NAME_D and they are almist 800 of them.

>

You'd better to add some prefix to these procedures. Make them
ZZ_table_name_U, ZZ_table_name_I and you will group them in the bottom
of the procedures list. Other procedures will appear always on top and
you will be free from scrolling down 800 procedures to find what you need.

--
Best regards,
Pavel Kutakov
SQLLY Development
Firebird Development Studio - complete development solution.
http://www.sqlly.com