We recently imported a database from another organization and noticed
that they had all kinds of users listed as owners for the various objects.
I need to change the ownership for every table to dbo. I am very new to SQL
Server so there maybe a stored procedure out there that will do this for me.
I have looked at sp_changedbowner and sp_changeobjectowner but I can't
figure out how to tell this procedure to work on ALL the tables. hints?