Well, sorry if we seem rude. I was trying to be funny. However, I think that coming to a photo forum the night before you are leaving in the morning to do a shoot is a bit... Short Sighted. Then on top of that you say you are taking a lovely Sony. You did not even bother to say if it was film or digital, Point and Shoot or DSLR. You don't say where it is, inside or outside, in a well lit auditorium or a dimly lit church. You basically came here gave us no information and ask for the "best" settings to get the "best" results. Even if you had a week to discuss all of this and gave everyone here the best possible amount of information available it would not be much help to you. Giving no information and a couple of hours for everyone to respond and you to read is just asking for trouble. Of the three people who responded so far, one told you you did not give enough information. The next told you the same thing and offered VERY good advice with the absolute minimum of information you provided. The third tried to be funny (which obviously failed) and in all reality gave you good advice as well. When the camera manufacturer made your camera they put in a LOT of effort to make the [Auto Mode] perform as well as it could. If they had no probably 50% of the people who bought it would not be happy with it and would return it.
Maybe the next time you come here, to a really great forum, you can do something to help us help you.