Are there any known issues with applying a newer service pack to a SQL Server hosting a Change Auditor database?
Change Auditor will support all subsequent SQL service packs within reason for a version (assuming no drastic changes from Microsoft side).