Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
r_sonakiya
Starting Member
25 Posts |
 Posted - 2001-11-27 : 09:21:08
|
| We have a table which stores information like credit card No. etc. How we can encypt the column of that table which stores this kind of information.Thanks,Ravi |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2001-11-27 : 09:44:45
|
| If you are using SQL server 7, there is an undocument function called PWDENCRYPT. It encrypts the data, however once you do that you will not be able un-encrypt it. You will have to use PWDCOMPARE to see it it is equal to another value.*************************Just trying to get things done |
 |
|
|
r_sonakiya
Starting Member
25 Posts |
Posted - 2001-11-27 : 14:26:51
|
| Royv,Thanks for your posting.Could you please give an example how to encrypt it and later how to deencrypt/decode it.Thanks,Ravi |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
|
|
r_sonakiya
Starting Member
25 Posts |
Posted - 2001-11-27 : 14:45:34
|
| Royv,Thanks for your very kind reply.Ravi |
|
|
|
|
|
|
Column Encryption