Thank you for the suggestion.
>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?
Chris McCandless
Red Sky Software