>Yeah, sorry I didn't see that before. To the best of my awareness you need a separate ALTER TABLE statement for each column.
>
>I vaguely recall trying different combinations of syntax before, to avoid separate ALTER TABLE statements, and I was never able to get it work. I think at one point Naomi and I were talking about this, and I don't remember if either of us ever came up with a solution (other than separate ALTER TABLE statements)
>
>I think you can do multiple ADD statements with just one ALTER TABLE, but I don't think you can modify multiple columns with just one ALTER TABLE.

Yep, I just remember this one as being counter intuitive so it bites me (or is that bytes me) every time.

But no big deal - here's the second pass ( cid is the pk in every table so I'll add code for that as well

DECLARE @script TABLE ( scriptstr VARCHAR(MAX) )
DECLARE @scriptstr VARCHAR(MAX)= 'Use InmateTrustfundx' + CHAR(13) + CHAR(10)

DECLARE @guids TABLE
    (
      tbl VARCHAR(100) ,
      tblid INT ,
      col VARCHAR(100) ,
      colid INT
    )

DECLARE @tbl VARCHAR(100)
DECLARE @col VARCHAR(100)
DECLARE @colid INT
DECLARE @tblid INT


INSERT  INTO @guids
        SELECT  tables.name ,
                tables.OBJECT_ID ,
                col.name ,
                col.column_id
        FROM    sys.columns col
                JOIN sys.tables ON col.object_id = tables.OBJECT_ID
        WHERE   system_type_id = 175
                AND max_length = 36
        ORDER BY tables.name ,
                column_id
 
WHILE EXISTS ( SELECT   *
               FROM     @guids ) 
    BEGIN
        SELECT TOP 1
                @tbl = tbl ,
                @col = col ,
                @tblid = tblid ,
                @colid = colid
        FROM    @guids

        SELECT  @scriptstr = @scriptstr + CHAR(13) + CHAR(10) + 'Alter Table '
                + @tbl + CHAR(13) + CHAR(10)
        SELECT  @scriptstr = @scriptstr + CHAR(13) + CHAR(10)
                + 'Alter Column ' + @col + ' Uniqueidentifier ' 
         
        IF @col LIKE 'cid%' 
            BEGIN
                SELECT  @scriptstr = @scriptstr + ' NOT NULL ' + CHAR(13)
                        + CHAR(10)
            END
        ELSE 
            BEGIN
                SELECT  @scriptstr = @scriptstr + '  NULL ' + CHAR(13)
                        + CHAR(10)
            END                      
    
 
        DELETE  FROM @guids
        WHERE   tblid = @tblid
                AND colid = @colid
      
        SELECT  @scriptstr = @scriptstr + 'GO' + CHAR(13) + CHAR(10)
    END
    

RETURN
    
    

Use InmateTrustfundx

Alter Table account_credits

Alter Column cid Uniqueidentifier  NOT NULL 
GO

Alter Table account_credits

Alter Column cinmates_id Uniqueidentifier   NULL 
GO

Alter Table account_debits

Alter Column cpurchases_id Uniqueidentifier   NULL 
GO

Alter Table account_debits

Alter Column cshiftlog_id Uniqueidentifier   NULL 
GO

Alter Table account_debits

Alter Column cbank_checks_id Uniqueidentifier   NULL 
GO
...