>Once in a while this place makes me think and reconsider old habits. You guys have convinced me not to use sp_ any more.Here's the way we named our Stored Procs.
We had what we called Basic Stored Procs which were prefixed with bsp_. We had a set of 3 basic procs for each table in the database, bsp_MyTableGet, bsp_MyTableDelete and bsp_MyTablePut (the Put did both updates and inserts). These basic procs were identical for all tables, except of course for the parameters, and simply did a get/delete/update/insert by PK.
Then we had Custom Stored Procs for more complicated stuff, prefixed with csp_.
In this manner, our customers were free to name their own Stored Procs, if they wanted to have some, with any prefix other than sp_, bsp_ or csp_ (we suggested usp_ for user).
~~Bonnie