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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2003-03-14 : 05:56:13
|
| i have a app done in vb i need my data is be encryption so that i can only read the data... is there a way of doing it... i have image , nvarchar,int,bit ... datatypes in my tables..a tip can do the rest======================================Ask to your self before u ask someone |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-14 : 06:38:48
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24515Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
Earthlinker
Starting Member
3 Posts |
Posted - 2003-03-29 : 01:44:24
|
| You have the wrong impression of the word Encryption. All SQL Server encryption is one way - PERIOD. Once encrypted, you can never go back - unless you figure it out.HOWEVER, if you set all of the tables to be SELECT to sa only (assuming that you are sa), then nobody can get to your data - except you. Sorry - but encryption is out of the question as far as encrypting something and then unencrypting it. No chance!!!JJS |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-29 : 05:23:04
|
| Yes but he didn't specifally ask about SQL Server encryption. If you read the linked thread, there are ways of doing it.Damian |
|
|
|
|
|
|
table data encryption