Best method I would think is to google for some one-way hashing function:
http://www.activecrypt.com/help/xpcrypt/step_by_step.htm
http://www.google.com/search?hl=en&q=mssql+password+hash+function


-----Original Message-----
From: Natalia Brett [mailto:mssqldba-ezmlmshield-x45693405.[Email address protected]
Sent: Wednesday, March 30, 2005 16:08 PM
To: LazyDBA Discussion
Subject: Encrypt and Decrypt information in the table

Hi,
we are going to store passwords in a column is there any native SQL function to
encrypt and decrypt, or do we need to create our own encyption algorithm??
(is there a system sp that is used to encrypt the SQL Server user
usernames??)

Thanks,
Natalia

The information within this e-mail is confidential and intended solely for the use of the recipient(s). If you are not the intended recipient then please notify Natalia Brett via email at Natalia.[Email address protected] or by telephone on +44(0)1244 319912. Then delete the email from your system. Please do not read, copy, print, forward, disclose, or use the information contained within this email. Note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Aktiv Kapital. Finally, the recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

Aktiv Kapital (UK) Ltd
Merchants House
Hamilton Place
Chester
CH12BE
UK
www.AktivKapital.co.uk




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



MS Sql Server LazyDBA home page