How can I change the owner of an object?

You can change the owner of an object using...

the stored procedure sp_changeobjectowner.

Example:


USE test
GO
EXEC sp_changeobjectowner 'Products', 'Pippo'
GO

'Pippo' becomes l'owner dell'object "Products", in this case a table.