• After reading a few articles and trial and error, the only procedure that worked was using

    sp_msForEachTable.