title: sql server 2008 password field encryption
body: <p>I have a table with username and password fields. Now i dont want the password to be stored exactly as a string the user inputted. I want this field to be encrypted or converted into a GUID so no one including people working on SQL can see it. 
  In case the user loses his password, he has to come up with a new one and it shall get updated in the table.
  Any ideas how i can achieve this?</p>