Symptoms
SQL Service broker
Diagnoses
How will changing the case sensitivity setting on a SQL database effect the SQL Smart Objects in that database
1. what steps would we have to undertake to maintain the data integration consistency
Resolution
This approach has not been tested on our side ever before, but one thing I do know is that it will effect the data that is being pulled back from the DB to the smart objects potentially causing further issues here. It may be a good idea to back up the database on your side and test on a development server, creating a service instance based on the DB after the collation change. This wouldn't be supported by us unfortunately.
Furthermore it may be good to look at the following two articles in regards to this:
http://mikerodionov.com/2015/06/installing-sql-server-instance-for-k2/
http://sqlmag.com/database-performance-tuning/seven-step-proCase%20sensitive%20databases%20are%20NOT%20supported.%20The%20following%20collation%20setting%20is%20required:%20Latin1_General_CI_AScess-changing-database-collation
