My current client use View to prefix the SP that create RecordSet use be C++ CGI Report for SP used by Crystal Report.

We do not use sp_ as prefixed because in SQL E.M. you find all SP at the same place.

Suggestion! Use:
Upd_ for SP that Update
Rep_ for SP use for report
SSP_ for SP that get call by more then on SP and create ##Temp. table

Ex: SSP_Upd_ResetLog is a SP that can get call be other SP and it do a update on the access log.

>Is there a naming convention for local stored procedures? I think the system stored procedures beging with sp_, and if I remember correctly, MS strongly advises against using that in the BOL. That makes sense, but is there a standard for local sprocs?