abhishek.sahoo (1/20/2009)
I am not sure whether we can use sys index to retrieve data from a linked server. The T-SQL you have provided works fine if the table is in same server. What if the table resides in a linked server.
I would run the code on the linked server, if possible..