[RESOLVED] SQL Script Creator

[Mark Gambo]

This is a little overkill but I used a Cursor to output the script the way I wanted it to look:

/*Change Owners of a table:*/
 
DECLARE @TargetOwner CHAR(25)
DECLARE @SourceOwner CHAR(25)
DECLARE @OwnerScript CHAR(100)
 
SET @TargetOwner ='dbo'
SET @SourceOwner = 'IA_ADM'
 
 
DECLARE TablesCC CURSOR
FOR SELECT 'exec sp_changeobjectowner ' + CHAR(39) + RTRIM(LTRIM(@TargetOwner)) + '.' + [Name] + CHAR(39) +',' + CHAR(39)+ RTRIM(LTRIM(@SourceOwner)) + CHAR(39) [Owner Change Script]
    FROM sysobjects
    WHERE xtype = 'U' AND UID = 5 
    ORDER by [Name]
 
OPEN TablesCC
 
FETCH NEXT FROM TablesCC INTO @OwnerScript
 
WHILE @@FETCH_STATUS=0
    BEGIN
        PRINT @OwnerScript
        PRINT 'GO'
        FETCH NEXT FROM TablesCC INTO @OwnerScript
    END
 
 
Close TablesCC
DEALLOCATE TablesCC