In our environment SQL development is divided between 3 groups and about 1/2 "freelancers".

Two of the groups and all of the freelancers have no convention.

In my team we following something like the function_subfunction_Description_Parameter format.

I set the function

UI - stored procs used to deliver functionality to a user interface

MAINT - used to perform application maintenance functions

REPORT - used for reports

The sub function is something like AR, ORDERS

The Parameter would CURRENT month, etc.

Its not documented well, but the three or four us work well together on it.