xp_md5.dll for 64-bit

Question

I am right now using this extended stored procedure in one of the test database on sql server 2008 and it works fine. I tried to do the same on a different sql server and it did not work on that. Then I got an explaination that the former was a 32 bit processor and latter was a 64 bit processor. Is there anyway to make use of this extended stored procedure on a 64-bit processor!!!

I need recompile version of xp_md5.dll for 64-bit.

Thanks in advance

Answer 1

If you want an MD5 why not use 2008's built in HASHBYTES()?

DECLARE @IN  NVARCHAR(4000) = N'Hello'
DECLARE @OUT VARBINARY(16)

SET @OUT = HASHBYTES('MD5', @IN)

SELECT @OUT