Encrypt a Column in sql server 2005
I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is it possible? I appreciate any help. I hope I made this clear enough. Thanks, Jay
Software/Hardware used:
Software/Hardware used:
ASKED:
March 7, 2008 4:39 PM
UPDATED:
March 10, 2008 12:59 PM
Answer Wiki:
This answer may help you
<a href="http://itknowledgeexchange.techtarget.com/itanswers/how-to-encrypt-a-column-in-sql-server-20002005/">http://itknowledgeexchange.techtarget.com/itanswers/how-to-encrypt-a-column-in-sql-server-20002005/</a>
If your C# application is using stored procedures to access the data then you can change the stored procedures to use the code in the above link. If you aren't using stored procedures then you'll need to get the source code to modify it. There is no way in SQL 2005 to encrypt a column without changing the code.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
