What techinques do you guys use when naming stored procedures?
I like to go by function but it was brought up by an Architech that a sp we are working on should be appended by application name.

We have over 3000 sp's here in just one database and by funciton really helps to find sp's for use in your app without having to accidentally rewrite a sp that already existed.

Example 1:
GetAllNotesForACustomerByCustomerKey

Example 2:
GetAllNotesForACustomerByCustomerKeyForApplicationXYZ

And getting out of hand example: 3
GetAllNotesAndActivityForACustomerByCustomerKeyBySortedNoteTypeAndDateRangeIfTheyHaveAnyNotesOrActiv ityAtAll

I like to also append "usp_" before the name to help filter user created sp's from system.
Example 1 is my preference.

Even if example 2 is specific to a single app, there is no real realson to add an applications name to teh end IMO.

Which do you guys do?