Another way is to use :

select * from sys.dm_db_missing_index_details

ALTER DATABASE mydb COLLATE SQL_Latin1_General_CP1_CI_AS

also can do the trick.

In design mode, click on the Package Explorer tab

Open the Log Providers node

You should delete the log file that is causing this problem.