sp_help

I am ashamed to admit I never knew about the sp_help and sp_helptext commands in sql server until today. Why has no one ever shown me this earlier?

sp_help will find a stored proc by just providing its name. It will then show all the matches, where they are located and what parameters they take.

sp_helptext will something similar, expect it will display the actual stored procedure. Much easier than hunting through a list.