Solved the problem (with the help of the above-mentioned link).

Turned out to be a problem with windows UAC 🙁

This is how I solved it in then end: http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

I'm disappointed. I've been doing this for a while with ROW_NUMBER and PARTION and it works gr8 in all the situations I've come across.

I can't figure out what advantage I...