• Oxygen thank you for the post your code got me 80 % of the way there. I modified your cursor to look for PK in the db that are non clustered then rebuild as clustered. I found 32 in first db looked. isn't rolling on to a new company great?

    SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME

    FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc

    inner join sys.indexes i

    on tc.CONSTRAINT_NAME= i.name

    where CONSTRAINT_TYPE = 'PRIMARY KEY'

    and i.index_id <> 1

    ORDER BY TABLE_NAME