SQL Server 2000 accept SHA-12 encrypted data

nphoenix
nphoenix used Ask the Experts™
on
Can SQL Server 2000 accept encrypted passwords for data storage in a table? (Hashed) specifically Sha-512&

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012

Commented:
Sure, it is just data.

Author

Commented:
So there's no field type or libraries in SQL to facilitate thsi.. i'll need to have my custom stored procedure or asp code do the encryption and decryption?  Nothing built into SQL will assist in this?
Top Expert 2012
Commented:
No, this is a function of the presentation layer.  If you were using SQL Server 2005/8 then you could use CLR.

Author

Commented:
Thanks  - if you have a second please clarify if the Common Language Runtime (CLR) you refer to still means its ucntions in .NET ready toi use verses "CLR" relating to somethin ing SQL 2005/2008.
Top Expert 2012

Commented:
Yes.  CLR = Common Language Runtime.  SQL Server has nothing built in.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial