SQL Server 2008R2 convert collation
Assuming those objects are stored procedures or views (and not tables), you'll need to:


script the objects in question
drop them from the database (or just remove the schema-binding)
change the database collation
recreate the objects by running the scripts you created in the first step.


As an aside, you didn't need to sp_msforeachtable "ALTER TABLE..."