Hello any body know how to Converting passwords (Md5 -> Normal)?
i found this query but this query only convert MD5 --> Normal
what i need is Converting passwords (Md5 -> Normal)DECLARE @Hash binary(16),
@myvarpass varchar(10),
@accid varchar(10);
DECLARE mytest SCROLL CURSOR FOR SELECT memb___id,memb__pwd FROM MEMB_INFO
OPEN mytest
FETCH NEXT FROM mytest INTO @accid, @myvarpass;
while (@@fetch_status = 0) BEGIN
EXEC master..XP_MD5_EncodeKeyVal @myvarpass, @accid, @Hash OUT;
UPDATE MEMB_INFO SET temphash = @Hash WHERE memb___id = @accid;
FETCH NEXT FROM mytest INTO @accid, @myvarpass;
END
CLOSE mytest
DEALLOCATE mytest
thanks.





