SQL Server 2008 R2 - how to repair System Views
AFAIK, your best bet is to copy all the tables to another database.  If you're using SQL Server express, this is something you have to do by hand, using SQL Queries or scripts.

It's a good idea to check for possible causes too: run a memory diagnostic, and a disk check.