My understanding is that connecting to linked AD (directly) only gives you select queries. No update, insert or deletes. I'm pretty sure that's what happened when I played with it.

You...

I think I get it now. Thanks.

True enough, but that's not what I'm asking. (My fault, I should have been clearer).

The question is: why does datename(dw,datepart(d,7)) returns a value of one day more...

I'm currently playing with a query that needs to return all the appointments for a physician three business days ahead of their appointments. I think I can deal with the...