title: storing passwords in SQL Server
body: <p>What is the recommended practice for storing user passwords in SQL Server 2008?</p>
  
  <p>I am storing user details for an intranet, and would like to get advice on best way to store a user details such as name, password and user access privillages etc. I am thinking of creating a nvarchar column and then encrypt this text before inserting into the table. </p>