Thanks, easy question as I have seen the automatic page repair live in a production system. It's a really cool feature. The status of the corrupt pages are stored in a table that you can Query to see if they are fixed or not.
First time I saw it, I was really surprised as I got an error in a Query that tried to select a corrupt page, but when I ran DBCC CHECKDB the corruption was gone.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform