I don't mind prefixes when it gives an indication of the objects purpose. For example, a [d] prefix for data tables, [ref] for reference data. Procedures like cussp_GetCustomerById, or addsp_GetAddressForCustomerId tell me immediately that they are customer and address procedures - and with the prefix they are logically grouped together in SSMS. What I hate is opening a database and finding all procedures prefixed [sp]! There is little point in that I think.