Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Encrypt and Decrypt Expand / Collapse
Posted Thursday, January 2, 2014 11:05 PM



Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:47 AM
Points: 199, Visits: 512
Hi All,

I have an requirement that, i have to Encrypt Salary's Information in my database. Basically, it has Employee's Salary Break Up details like LTA, Basic, Special Pay....

So from the above one, i need to Encrypt all the Salary's Information and Decrypt the same when it required. I have seen some Built in Functionalists say EncryptByPassPhrase, EncryptByKey....

Can you please suggest me, Are there any other way where i can do this Encryption?

Thanks All....
Post #1527350
Posted Sunday, January 5, 2014 6:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, May 8, 2014 6:43 PM
Points: 57, Visits: 97
You are right, there are built in functions. I can't imagine why you would not use them, but the only sensible alternative is to use the Cryptography namespace in C#, and follow this:

to use CLR code inside SQL Server.
Post #1527947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse