sha-256 in sql 2008 - 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 2008 Forums

Transact-SQL (2008)

sha-256 in sql 2008

Author

Topic

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-09-14 : 13:30:02

I have a password column in database that got already existing rows sha-256
encrypted passwords I am adding new rows thru stored procedures I am not using .net how to encrypt the new password using sha-256 using sql transact
thanks

sarah

Kristen
Test

22859 Posts

Posted - 2011-09-14 : 14:11:07

Probably no help by next version of SQL Server "Denali" will have this in HASHBYTES

sarahmfr
Posting Yak Master

214 Posts

Posted - 2011-09-15 : 00:38:42

Thanks

sarah

innoya
Starting Member

2 Posts

Posted - 2013-06-06 : 02:31:38

SHA256, SHA512 in SQL SERVER 2008 OR SQL SERVER 2005!

fnEnCryptSHA!

USE [master]
GO

EXEC sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

CREATE ASSEMBLY InnoDll
FROM 'C:\inno\fnEnCryptSHA.dll'
WITH PERMISSION_SET= SAFE
GO

unspammed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources