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 |
|
radha
Starting Member
11 Posts |
 Posted - 2005-01-23 : 22:39:24
|
| I need to encrypt the Data in the Patients table during Storage.In the Same way I need to decrypt also.How to do this one in Sql Server 2000.Please anyone help me.Bye |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-23 : 22:57:59
|
| http://www.sql-server-performance.com/ck_database_encryption.asp==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
radha
Starting Member
11 Posts |
Posted - 2005-01-23 : 23:24:23
|
| That website is used for Encrypting the File.I am asking ,the Encryption in Table level. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-23 : 23:29:43
|
| There's nothing built in to sql server that will encrypt a table.You can do it yourself if access is via stored procs.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
hgorijal
Constraint Violating Yak Guru
277 Posts |
Posted - 2005-01-24 : 00:39:33
|
You can not encrypt an entire table..How ever, you can encrypt the data in a column before storing it.two ways, You can write a custom function (UDF) to encrypt and decrypt the data (might want to compile the UDF with "ENCRYPTION" option, to keep the code safe)OR You can use the built int encrypt() function. (note : there is no decrypt() function) hthHemanth GorijalaExchange a Dollar, we still have ONE each._______Exchange an Idea, we both have TWO each. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-01-25 : 04:07:15
|
quote:
Originally posted by hgorijal You can use the built int encrypt() function. (note : there is no decrypt() function)
 , like giving a bomb to a kid and say it's a ball--------------------keeping it simple... |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2005-01-25 : 09:50:32
|
| What is supplying the key for the encryption? |
|
|
|
|
|
|
Data Encryption!