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
Go to Top of Page

sarahmfr
Posting Yak Master

214 Posts

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

sarah
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -