Change Collation and refresh


I change the collate of all string columns in the production DB.
of course I remove constraint and after i create them.
the views and SPs were alter.

do I need to refresh all objects ? or which objects exactly ?
when it is necessary to use sp_refreshsqlmodule ?

If you altered all the stored procedures that automatically also did the equivalent of sp_refreshsqlmodule, so no need to do the refresh again.

You miay want to look at other objects - e.g. functions to see if they are impacted.