[dba-VB] Encrypt password

To all,

I'm starting to write a vb.net app which will link to a sql server
database, I want the passwords in the user table on the SQL server database
to be encrypted one way, then if they forget the password can request a new
one.  Firstly I used to use MD5 when I worked at my last company, but have
heard this can be cracked, anyone have any other recommendations, I don't
mind if the password encryption happens on the vb.net app or the sql server
database.

Thanks in advance for any help.

-- 
Paul Hartland
paul.hartland at googlemail.com