WORKAROUND 1:
Restart the SQL Server service on the server to prevent the 100% CPU.
WORKAROUND 2:
Disable Error Log Scanning:
1. Right-click the SQL Server 2005 connection | go to properties.
2. Click on the Monitoring tab.
3. Click the Error Log Entries link.
4. Check the box, Override the factory settings | un-check the Enable error log scanning box.
5. Click OK.
STATUS:
Waiting for a fix in a future release of Spotlight on SQL Server Enterprise.
