Need quick MSSQL code to change passwords and email them.

I need a script to automatically go through every account in my game database and change their password and send an email to their registered email address with the new password. This is due to a leak of password information for my game server. You can view the current registration code here to know where this information is located in the MSSQL database. http://past [login to view URL] Notes: The password must be changed in two tables. Plain text in tbl_user and converted to MD5 Hash in USER_PROFILE table. Emails I will provide further information via pmb. Thanks