Member Avatar for judithSampathwa

Hi there,
How can I use the “EncryptByPassphrase” for a table in ms sql server 2008 r2???
or if i can get a good tutorial appriciate a lot
thanxxxx

  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

If you understand what a cipher text is and how to encrypt and decrypt data that should be quiet easy task for you.

1. Collect data
2. Encrypt (using algorithm )
3. Store in DB
4. Retrieve.
5. Decrypt using reverse algorithm.
6. Use the record.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.