Can I change owner of another database table from different database on the same server.
Let's say, I have two databases d1 and d2, I am trying to run following from d1. Is it possible?
sp_changeobjectowner 'd2.x.table1' 'y'
changing ownership 'x' to 'y' on d2 database from d1 database in query analyzer