In the link provided by Craig, they suggested using either the name of the Action first:

csp_GetPerson

or the name of the table first:

csp_PersonGet

I have always preferred putting the table name first, that way they all get grouped together, making them easier to find in SSMS. I also put an underscore after the table name (I think it's more readable):

csp_Person_Get

That suggestion isn't limited to table names, you could also use business processes (if the Stored Proc is going to be accessing several tables). For example:

csp_Orders_GetHistory
csp_Orders_GetCustomer

~~Bonnie


>I am sure this question has been asked a million times. And yet I am asking it again. I see everywhere online stored procedures named with prefix sp (e.g. sp_custom_account). Is there a technical or a logical reason for that? Since stored procedures are in SQL DB Programmability -> Stored Procedures, why need to tag them as SP still?