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.
Author |
Topic |
collie
Constraint Violating Yak Guru
400 Posts |
Posted - 2007-11-08 : 06:09:22
|
Hi,I need 2 stored procedures one that will decrypt MD5 password and another that will encrypt the password. Can someone please help me? I have no idea where to start.ThanksWhisky-my beloved dog who died suddenly on the 29/06/06-I miss u so much. |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-08 : 06:44:35
|
MD5 isn't an encryption it's hashing.so you can't unhash it. once you hash it that's it...DECLARE @HashThis nvarchar(max);SELECT @HashThis = CONVERT(nvarchar,'dslfdkjLK85kldhnv$n000#knf');SELECT HashBytes('MD5', @HashThis); _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|