>>Hi,
>>
>>My application has a password table (straight forward, user name/id, password, email, etc.) which I currently encrypt with my own (written in VFP) very simple code. As I move the application more towards .net environment and the same database has to be accessed from .net side. So I would like to convert my own encryption into something that is built into SQL Server so that both VFP app and .NET app can use it transparently. Is there a feature in SQL Server that would allow me to "move" the encryption to the SQL server and have both VFP and .NET use it?
>>TIA.
>
>Are you encrypting or hashing? For passwords it may be better to just keep hash and SQL Server has HashBytes function for this. It does, of course, has encryption as well.
I am embarrassed to admit that I don't know the difference between encrypting or hashing. My application does not have any sensitive or financial information. So a very basic (the simpler the better) way to protect the records in the password file from being visible to anybody is what I am looking for.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
