I wouldn't bother trying to attach it. The damage you have is not repairable in any way. Get out your backups and restore the DB from the latest backup.

The table that's damaged (object ID 4) is sysrowsetcolumns. It's one of the tables that stored data about column structure. It's not likely that you will be able to extract all the data from the DB due to this error.