Table Encryption - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Table Encryption

Author

Topic

sona
Yak Posting Veteran

68 Posts

Posted - 2001-12-31 : 02:18:04

hai,

is it possible to encrypt one or more columns in a table

Nazim
A custom title

1408 Posts

Posted - 2001-12-31 : 02:58:56

in SQL server 7, you will find PWDENCRYPT to encrypt the data . and therez no way to decrypt it, you can compare your encrypted data with another value with PWDCOMPARE function.

there have been pretty good discussions on Encryption on sqlteam forums.
here are few of them
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=10961( i think this should help you)
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=8657
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=5451
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9050

therez an article too
http://www.sqlteam.com/redir.asp?ItemID=6391

i would suggest you to search encrypt in forum search. you can get loads of good links.

HTH

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2001-12-31 : 03:12:10

Nazim is right, those searches will give you a good background. But one way is use a 3rd part component like ASP Encrypt to encrypt the data before it gets passed to SQL Server.

Hope that helps

Damian

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources