Never.
When you apply SP2, it adds additional catalog files to the OS. Whenever the OS needs to reinstall a file, it will always check the Service Pack catalog to see if it should take the file from the SP or from the base media.
You should never have to reinstall the service pack.
(Yes, I realize the dangers of the word 'should.')