Set the notification tones in the Application itself. So for text messages, open the Messaging App, then hit the Menu button at the bottom of the phone (far left button) > Settings > and under "Notification settings" hit Select ringtone and choose one.
Do this in each Application that generates notifications (email, gmail, etc) and do the same thing.