Case sensitive compare using PWDCOMPARE()

Hi,
I am trying to do a case sensitive comparison using pwdcompare(). But it doe
snt seem to work. I apprieciate help in this regard.
RameshPassword case sensitivity is determined by the instance default collation.
I haven't tested this but I suspect that the undocumented pwdcompare compare
function uses a one-way hash determined by the default collation. As such,
a case-sensitive comparison of hashed value is not possible with a case
insensitive default collation.
In any case, it's a good idea to avoid undocumented functionality in
production code.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ramesh" <anonymous@.discussions.microsoft.com> wrote in message
news:C737C23D-A190-4A0C-9003-5F1B9B4751E6@.microsoft.com...

quote:

---

> Hi,
> I am trying to do a case sensitive comparison using pwdcompare(). But it

---

doesnt seem to work. I apprieciate help in this regard.

quote:

---

> Ramesh

---