SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 sha-256 in sql 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sarahmfr
Posting Yak Master

214 Posts

Posted - 09/14/2011 :  13:30:02  Show Profile  Reply with Quote
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

United Kingdom
22431 Posts

Posted - 09/14/2011 :  14:11:07  Show Profile  Reply with Quote
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 - 09/15/2011 :  00:38:42  Show Profile  Reply with Quote
Thanks

sarah
Go to Top of Page

innoya
Starting Member

2 Posts

Posted - 06/06/2013 :  02:31:38  Show Profile  Reply with Quote
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

http://www.inno.jp/Tools/fnEnCryptSHA.aspx

Edited by - innoya on 04/14/2014 07:21:39
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000