Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL Server 2000 Encryption Tools Expand / Collapse
Posted Saturday, March 25, 2006 10:32 AM


Group: Moderators
Last Login: Yesterday @ 1:07 PM
Points: 7,062, Visits: 2,667
Comments posted to this topic are about the content posted at

SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #268455
Posted Tuesday, July 7, 2009 10:44 AM


Group: General Forum Members
Last Login: Friday, November 4, 2016 1:32 PM
Points: 117, Visits: 489
I am working on SQL Server 2000 and I have a table containing a password field. I have to add a new column to the table and convert all the exisiting password fileds to encripted password exploiting sha256 algorithm. CAn you help me with any stored procedure or extended stored procedure.

Post #748723
Posted Tuesday, July 7, 2009 11:33 AM



Group: General Forum Members
Last Login: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
First of all you cannot implement (without EXTREME PAIN) sha256 in a stored procedure..

With that said however, you can get an extended stored procedure that that can handle it, I found one for you at:

As I see it, you create an additional column, hash the passwords into it and then delete the previous password column. Make sure that whatever you use in your apps to hash the entered password that it creates hashes that are the same, they may both be sha256 but you never know who might have screwed up..


Post #748748
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse