Muralidharand
asked on
Generate Hash Key in SQL Server 2005 using SHA 512 algorithm
How to generate hash keys for a table data in SQL Server 2005 using SHA 512 algorithm?
before running the above sql you will have to "Enable Ole automation" for SQL Server.
Follow these steps:-
start -> programs ->MS sql 2005 -> configuration tools -> surfce area configuration -> Surface area conf for features ->
Ole automation -> select the Enable check box and save
Follow these steps:-
start -> programs ->MS sql 2005 -> configuration tools -> surfce area configuration -> Surface area conf for features ->
Ole automation -> select the Enable check box and save
OLE Automation can also be enabled through:-
exec sp_configure 'Ole Automation Procedures', 1
go
reconfigure
go
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Depending on the length of the string, you can possibly use HASHBYTES. Hashbytes supports SHA and SHA1.
http://msdn.microsoft.com/en-us/library/ms174415%28v=sql.90%29.aspx
http://msdn.microsoft.com/en-us/library/ms174415%28v=sql.90%29.aspx
ASKER
Your post was helpful.
Open in new window