Good question, but do agree the explanation could be improved.

I assume they need access to these other tables too, or you could restrict access to the tables you don't want them joining to.

You could use a stored procedure. ...

Very good QoTD, thanks!

Good question. I almost answered under the assumption the Order table had an ID column, but realized it was named differently in time.

I don't think you can do that with replication, but you could do it with stored procedures that read and write to both databases. A view could read from...

Glenn Berry's blog and presentations are pretty useful for this, at least at the high level:

The first three here are good have some nice references:

Accidental DBA Series[/url]

Depending on your edition...

Thanks for showing me a better way diamondgm, I haven't really used WITH ROLLUP before.

Control...

You could use a recursive CTE instead of temp table. I used a temp table to simulate your result set (and added a couple sections for testing), but you...

Easy question, but good 🙂

Good question, this is a feature I haven't had to use yet.

Good question. Thanks Kapil!