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

---

Capturing Changes In Data

I'm looking at how SSIS would cope with populating DW with huge transactional tables capturing only changed data.
Can you use a table comparison transform, or is the approach to look at timestamp log files and 'Last Exection Date variables'.

Any comments appreciated

Yes, these are the general approaches.
You also have the option of transaction replication to a staging table, and then periodically running your ETL process.
K