But, in this case:  exec sp_addalias 'Domain\Tom','dbo'    doesn't the second parm have to be an actual login ?   so 'dbo' is a sql login with dbo rights in the database...

Thanks ... I understand about manually creating tables & SPs.  I was hoping there was some sort of administrative way to make objects automatically be "dbo" for them for when...

What's a split set ?

I guess the whole post went flying over my head ....  

I understand your & Atra's select statements, but I don't understand that big query you posted after that. I ran it, and I got a bunch of system stuff, but...

Ummmm .... Could you explain what that all does ??