Posted by David Portas on 07/04/07 09:59

On 3 Jul, 16:47, ArunDhaJ <arund...@gmail.com> wrote:
> Hi Friends,
> What is the equivalent function of pwdcompare() in Sql2005?
>
> Thanks,
> ArunDhaJ

PWDCOMPARE is an undocumented function in 2000 and 2005.

To hash and compare passwords you can instead use the HashBytes()
function in SQL Server 2005. I don't think HashBytes will be
compatible with the hashes used by PWDCOMPARE.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

• Next in forum: Find website from email address
• Prev in forum: Re: How can I combine different rows?
• Thread view: Re: pwdcompare equivalent in Sql2005

[Reply to this message]