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)
 how to save password field in database table in encrypted format

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-27 : 08:58:33
Khalid writes "My Question is that

I have a table in my database called Users. This table has two fields User_ID or Password Field. Just Like That

User_ID Password
======= =========
Khalid computer
Safdar monitor
Adeel printer

i want that my password field of this table save in encrypted format in table.

Thanks"

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-04-27 : 09:35:05
It's better to encrypt at the application level. For more information see www.asp.net. They have several good articles on encryption with SQL Server.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2004-04-28 : 09:28:01
If you want to encrypt right out at the Client, in Javascript on a web page maybe!, then these guys pretty much have it covered

http://pajhome.org.uk/crypt/md5/

Kristen
Go to Top of Page
   

- Advertisement -