Encrypting Field

[Grif]

How do I encrypt fields in SQL Server?

thanx

 

[tlbroadbent]

There is no supported, documented way of doing this.

Check the SQL FAQ at

http://www.sql-server.co.uk/frmMain.asp

for more information, additional links and some more ideas about SQL Server encryption. You'll have to register at this site.

Outdated copies of the SQL FAQ with much of the same info are available at

http://www.swynk.com/faq/sql/sqlserverfaq.asp

http://www.mssqlserver.com/faq/

http://www.windows2000faq.com/Articles/Index.cfm?DepartmentID=800

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.

 

[balves]

Microsoft has a simple encrypt/decrypt routine that you can use from VB and ASP. I've used it to encrypt fields before storing them in a SQL Server database. It's so short, I'll post it here.

You pass it the string you wish to encrypt/decrypt and a password. The first time you pass the string it encrypts. Call it again with the same parameters, it decrypts.

Public Function Encrypt(strInput As String, strPassword As String) As String
Dim L As Integer
Dim X As Integer
Dim Char As Integer
' strInput = the string you wish to encrypt or decrypt.
' strPassword = the password with which to encrypt the string.
L = Len(strPassword)
For X = 1 To Len(strInput)
Char = Asc(Mid$(strPassword, (X Mod L) - L * ((X Mod L) = 0), 1))
Mid$(strInput, X, 1) = Chr$(Asc(Mid$(strInput, X, 1)) Xor Char)
Next
Encrypt = strInput
End Function

Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / ASP / Crystal / SQLServer