Create a folder called Notifications, then store any sound file you want in there. Then in Messgaing app hit menu, settings, then right down the bottom hit Select Ringtone. The pop up menu should contain any file you added to your folder 'notifications'.