Mass Database Table Ownership Change May 31 2007
DECLARE @old sysname, @new sysname, @sql varchar(1000)
SELECT
@old = ‘{ THE OLD OWNER NAME }’
, @new = ‘{ THE NEW OWNER NAME (eg. dbo) }’
, @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