Hello,

I need to know about the encryption types supported by MS Sql. and how
can we store password in data base in encrypted form.

Is there any article upon this issue.

Regards,

junior

[quoted text, click to view]


Take a look at:

http://msdn2.microsoft.com/en-us/library/ms189586.aspx

Don't encrypt passwords unless you must have a password recovery
mechanism. Password recovery is itself a potential security weakness
so it is usually better to hash the password instead of encrypting it.
Password management, especially complexity and expiration rules are
very important if you store passwords in any form.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--