I don’t know how other DB guys dealt with this problem but I get frustrated looking for the stored procedure
Shopfront_Readonly.usp_DataReader_GetFirstXProductWithSixDigitBarcodeAndRelatedCustomerInformation among a thousand other procs all having the same schema and prefix.
Why not download SQL Search from Red Gate and start searching DB objects like searching in the Windows 7 start menu. SQL Search has to be the best free add-on to SQL Management Studio. It indexes your database for once and search whatever you need in seconds. It’s as easy as installing it and press Ctrl + Alt + D or click the SQL Search button to bring it up.