Tag Archives: SQL Change Owner Script

sp_changeobjectowner [ @objname = ] ‘object’ , [ @newowner = ] ‘owner’ SELECT ‘EXEC sp_changeobjectowner ”’+ SCHEMA_NAME(schema_id) + ‘.’ + OBJECT_NAME(object_Id) + ”’, ”dbo”’FROM sys.tables In order to change the owner of an object in the current database, use the … Continue reading →