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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2007-01-09 : 14:57:40
|
| GurusI have a table with adminpwd as column and data type for this is varchar.Now i want to encrypt and decrypt it.and i have my first column as id (pk) with identity on.My first question is1)Will it work with identity on?2)DO i have to change the data type to varbinary?Please helpRegardsNitin Gupta |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-09 : 14:59:40
|
| Why would you like to encrypt the identity value?Have you thought of primary/foreign keys?Peter LarssonHelsingborg, Sweden |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2007-01-09 : 15:02:34
|
| No,i am nt encryptin the identity column.i am encrypting adminpwd column.RegardsNitin |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2007-01-09 : 15:07:17
|
| and if i change the data type to varbinary and identity is on the data is encrypted,but when i deccrypt it thru the view,it shows me null in that column.RegardsNitin |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Encryption Problem