I am using a linked server to select data from one SQL server to another SQL server database.
The problem is
select EMPLOYEE_ID From xxx.xxxx.dbo.EMPLYEE_TBL does not work over linked server in target DB.
select Employee_Id From xxx.xxxx.dbo.Emplyee_Tbl works fine


the same sql
select EMPLOYEE_ID From xxx.xxxx.dbo.EMPLYEE_TBL works fine in taget DB

is the linked server causing the case problem? Is so how to handle the case issue over linked server