Ok further debugging, I found that when I ran the same query with the linked server in the query window it executes.

It only gives an error when used with trigger....

I think that's what the link specifies.... Tried that still no luck.

I think there may be some issues of PORT NO, but again i have set it to dynamic port.

Yes, that is the requirement similar to SQL DOC. But do we have any open source utlity.

What do you guys think of index that has been done on the Table provided?

Should I created individual indexes for each column in the where clause?

Hi Guys,

I have attached the Table Schema and the SP used to execute.