How to Change Table and Stored Procedure Ownership in sql server

Introduction

In this snippets help to you change the ownership for the table or stored procedures using T-SQL.

Script for change table ownership

DECLARE @old sysname, @new sysname, @sql varchar(1000) 

SET @old = 'oldOwner'
SET @new = 'dbo'
SET @sql = ' IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
WHERE
QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
AND TABLE_SCHEMA = ''' + @old + ''' )
EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

EXECUTE sp_MSforeachtable @sql

change ownership for stored procedure

DECLARE 
@OldOwner sysname, 
@NewOwner sysname 

SET @OldOwner = 'oldOwner' 
SET @NewOwner = 'dbo'

DECLARE CURS CURSOR FOR
SELECT 
name
FROM sysobjects
WHERE type = 'p' 
AND 
uid = (SELECT uid FROM sysusers WHERE name = @OldOwner) 
AND 
NOT name LIKE 'dt%' FOR READ ONLY

DECLARE @ProcName sysname
OPEN CURS
FETCH CURS INTO @ProcName
WHILE @@FETCH_STATUS = 0
BEGIN 
IF @@VERSION >= 'Microsoft SQL Server 2005' 
BEGIN 
EXEC('alter schema ' + @NewOwner + ' transfer ' + @OldOwner + '.' + @ProcName) 
exec('alter authorization on ' + @NewOwner + '.' + @ProcName + ' to schema owner') 
END 
ELSE 
EXEC('sp_changeobjectowner ''' + @OldOwner + '.' + @ProcName + ''', ''' + @NewOwner + '''') 

FETCH CURS INTO @ProcName
END

CLOSE CURS
DEALLOCATE CURS

Hopes this helps.thank you reading.