Change Owner Name for SQL Server (Table, Stored Procedures)

Use this command below to change the owner name of table or stored procedures in SQL Server

1
2
exec sp_changeobjectowner 'TABLE_NAME', 'dbo'
exec sp_changeobjectowner 'STORED_PROCEDURES_NAME', 'dbo'