How do I trigger a reset password?

[ladecarim]

I work in Microsoft .NET 4.0 environment.In my application I enable the user to get new automatic password.So I use in my .cs file the method:\[code\]MembershipUser user = Membership.GetUser();user.ResetPassword();\[/code\]I want to trigger on reset Password, means: when the password is changed to the automaticone, an email will be sent to the user's email address with the new password (that is returned from user.ResetPassword()).I use standard Membership DB tables.I wrote the following trigger:\[code\]CREATE TRIGGER MembershipChangePass ON aspnet_MembershipAFTER UPDATE,DELETEASBEGINDECLARE @user uniqueidentifierDECLARE @email nvarchar(256)SELECT @user = (SELECT UserId FROM UPDATED)SELECT @email =(SELECT LoweredEmail FROM aspnet_Membership WHERE @user=UserId)EXEC xp_sendmail @email, ??? ENDGO \[/code\][*]The problem is how do I get the ??? - the new automatic password I created bythe method: user.ResetPassword();[*]Can I define the TRIGGER to be used only with user.ResetPassword(), and not with other methods (like: (user.ChangePassword(...))?[*]Maybe there is another simple way to trigger reset password?Thank you.