you can go to your profile app and scroll to the bottom were it says advanced. this will take you to a list of your profiles were you can pick one and change all sounds for each app you have from your ringtone to your alarm clock.
Posted from my CrackBerry at wapforums.crackberry.com