One of our team members added a new column to the table tblOrders, now we get an collation error on a select condition where there is a JOIN with another table
This was the change that was made
exec sp_repladdcolumn 'tblOrders', 'orderregion', 'varchar(60) NULL'
exec sp_recompile tblOrders
Not sure what is the reason this is occuring, and how do we fix it