Curently, we have all named user logins with a passwd expiration interval set for 30 days. My question is if a user requests to have his password reset, how can I reset his password, and force it to expire on that first login without using sp_modifylogin to change the passwd expiration parameter from 30 to 1?

Thanks.