title: How to Encrypt SQL Server 2008 Database
body: <p>I have a database which currently is using by my application. I dodn't want to change <strong>anything</strong> in my application CORE. But I want to encrypt <code>DATA</code> and <code>INFORMATION</code> in which <code>stored</code> or <code>is storing</code> in database.</p>
  
  <p><code>SQL Server 2008</code> (or 2008 R2) should have an internal mechanism to encrypt and decrypt information which given and taken to application.</p>
  
  <p>How to get it to work? Encryption is needed for all of the fields in Database, numerics, strings, booleans, datetimes, etc.</p>
  
  <p>Any help is appriciated</p>