I use a slightly different approach (despite of the usp_)
>> Module_Object_Action
I can divide my stored procedures to operate in different parts of the DB (CRM, Statistics, Reporting etc.). That's a module (call it whatever you want)
Then, I have objects. This includes all tables and views I'm operating on, but can also be something abstract like sales, inventory or so.
Finally, I would have actions operation on the objects. I would use 'Edit','Delete','Insert','Generate','Calculate' or whatever.
Now, if I sort the SP in the Enterprise mangager, I have them nicely grouped by module, object and action. procedures which operate on the same object in the context of a module are listed together. That's exactly what I need.
Examples are:
CRM_Customer_Append
CRM_Customer_Delete
CRM_Customer_Modify
Stats_Sales_Report
Stats_Customer_Listing
Stats_UnfinishedOrders_Listing