right so you've click on profiles
you've gone to advanced
you've highlight the profile you want to change i.e. normal
then menu - edit
then there is a list of things you can change
scroll to SMS
then change the ringtone next to RINGTONE:
"That's it then. Cancel the kitchen scraps for lepers and orphans, no more merciful beheadings... and call off Christmas."