Fabrice has compiled a nice list of bug tracking software.  We have recently started using FogBugz here for FinalBuilder, and it really works well.  Probably the best feature is that it acts as an email client for our support system.