Encrypt a field in the database.
-
Hi, I have a field in the database that has credit card number in it. Bottom line, how can we encrypt this information using SQL SERVER? I need to encrypt it for a brief period of time, like 15 minutes, then the table is truncated. I am using sql server 2005 within C# program/
-
Hi, I have a field in the database that has credit card number in it. Bottom line, how can we encrypt this information using SQL SERVER? I need to encrypt it for a brief period of time, like 15 minutes, then the table is truncated. I am using sql server 2005 within C# program/
This[^] topic describes how to encrypt a column of data by using symmetric encryption in SQL Server 2012 using Transact-SQL. --edit There's a dropdown at the top of the page that brings you to the same topic for Sql Server 2005[^].
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] They hate us for our freedom![^]
-
Hi, I have a field in the database that has credit card number in it. Bottom line, how can we encrypt this information using SQL SERVER? I need to encrypt it for a brief period of time, like 15 minutes, then the table is truncated. I am using sql server 2005 within C# program/
I have not seen encrypting one field as a function of a SQL database. Most of the time encryption and decryption is performed at the application level. I can't speak for other programmers, but I use a salted MD5 algorithm in my code that encrypts and decrypts password fields and other sensitive data. http://stackoverflow.com/questions/5061003/how-to-encrypt-the-password-column[^]