It isn’t often that I need such a thing, but occasionally I get asked by an engineer to change the owner of a database table in MS SQL 2005. This happens sometimes, though I cannot always remember how, but changing the owner of a table is pretty easy. Just execute the following script, making sure you are logged in as “sa”.

exec sp_changeObjectOwner 'originalObjectOwnerAndName', 'newOwner';

For example, if the object name is “MyTable1”, and is owned by “DOMAIN1\User1”, and you wish it to simply be “dbo”, then you would do the following:

exec sp_changeObjectOwner 'DOMAIN1\User1.MyTable1', 'dbo';

Pretty simple.