I am in the middle of doing a consolidation project. Several of the databases i have marked for consolidation has a different collation from most of the others. The others have standard SQL_Latin1_General_CP1_CI_AS but the others have Latin1_General_CI_AS. What i was thinking about doing was after migration, running a script over my database to change the column collations to the SQL_Latin1_General_CP1_CI_AS collation and changing the database collation so that they are all the same. My database uses the temp DB and was hoping this would help me avoid any problems in this area. What i would like to know is what risks would i have, from a data and an application perspective.