Static data not working for databases with different Collation
説明
After clicked on Link static data on the selected table, nothing happened. The icon didn't change and it never showed up in the Action center tab. The different collation between ApexSQL and linked databases is what caused the issue: The database collation for ApexSQL is Latin1_General_CI_AS_KS_WS and the linked database collation is SQL_Latin1_General_CP850_BIN2.