The sound is part of the Window Sound scheme. S12 uses the default Windows Exclamation sound. You can change it by editing your sound scheme settings. (in XP, at least).
My guess would be it uses a standard Windows GUI call to generate the beep, so changing the S12 beep without all the other exclamation events also changing might be a bit tricky.