I had setup linked server and when i query the it gives me below error.
SELECT top * from [Servername].[WH_SYSTEM].[dbo].T_ENCOUNTER_PHYSICIAN
WHERE PhysicianID LIKE '[0-9]%'
Msg 7357,Level 16, State 2, Line 1
Cannot process the object ""WH_SYSTEM."dbo"."T_ENCOUNTER_PHYSICIAN"".
The ole db provider "sqlncli10" for linked server '' servername" indicates that either the object has no columns or the current user does not have permissions on that object.