Go to profiles>go to advance>pick a profile>go to sms msgs>scroll to tune and change option. Keep in mind at this point you should have the ringtone saved.
Just remember if you dont have a memory card you will be eating away at your internal memory. If it drops below 10mb you are gonna lose messages and other stuff possibly as it makes space. Oh and welcome to CB.