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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-08-13 : 14:31:27
|
| How do i encrypt a particular row in a table.and how will i decrypt it back |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-13 : 14:39:42
|
| you can't encrypt just one row. this is what you can encrypt:- Passwords- Definitions of stored procedures, views, triggers, user-defined functions, defaults, and rules- Data sent between the server and the clientyou can't encrypt data in tablesGo with the flow & have fun! Else fight the flow :) |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-13 : 15:16:30
|
| i want the rows in the tables encrypted.i dont want SSN and credit card details in the table stored to be seen |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-13 : 15:25:24
|
| well, then you have to insert them already encrypted.Go with the flow & have fun! Else fight the flow :) |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-08-13 : 18:59:03
|
| http://www.codeproject.com/database/xp_md5.aspThis is an excellent way of encrypting stuff in the database. Making an MD5-hash is considerd to be very strong, however you have to be aware that it is only one way. It will generate a 32-character long unique "checksum"-value that you can store in the database and when you want to compare something just do the encryption first on whatever you want to compare. It's pretty straight forward... |
|
|
|
|
|
|
encrypt