I too like the elegance of the UNION solution. Could be I'm missing something, but wouldn't UNIONing the two tables against themselves first eliminate the problem of reporting tables...

From a DBA standpoint I agree that requiring all objects owned by DBO is, by far, the simplest and most error-free method. However, how to do that appears to...