• As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...

    I am sorry but I didn't get you. You are facing some issue with Linked Server and you know the reason for that issue. Then why are you posting it here? Is it FYI post?