Hello everybody I wanna know if we can do this in the n900???? thanx
Yes, you can set Ringtone, a SMS sound, an IM sound and an email sound. You can use any mp3 file for this.
Although, it seems that there is currently no way to set different sounds for different people or groups, only for profiles.