Just to revive the thread once more, I am facing this issue in SQL 2014, and struggling with it. The only real difference is that this is not a table that I am struggling with, but a Stored Proc, so my error is...
Msg 468, Level 16, State 9, Procedure sp_PROC_NAME, Line 40
Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "Latin1_General_CI_AS" in the equal to operation.
Msg 12813, Level 16, State 2, Line 15
Errors were encountered in the procedure 'dbo.sp_PROC_NAME' during compilation of the object. Either the containment option of the database 'DATABASE_NAME' was changed, or this object was present in model db and the user tried to create a new contained database.
...looking what has previously been suggested in the thread, I'm having trouble putting two and two together. Can someone please help me with this? At this point I'm not sure if this issue was cleared up in 2014 or not. I'm running SQL 2014 SP1.