Our application is tied to a database on SQL server. The application upgrade is failing because duplicate objects are detected in a table which share the same ParentID - these objects contain the same Name but with different case sensitivity. It appears collation was changed on the Name column -- collation settings below.
select * from TREE
I'm looking for a way to locate all objects in the TREE table that contains:
1. The same ParentID
2. The same Name, regardless of case sensitivity
Is there a SQL query that can help locate the requirements above? I'm doing my best with Google but haven't found what I'm looking for.
SQL 2014 instance: SQL_Latin1_General_CI_AS
ACME database: Latin1_General_CI_AS
TREE table: Latin1_General_CI_AS
NAME column: SQL_Latin1_General_CP1_CS_AS