I know this does not explain your problem, but have you tried creating a new table with the new definition? Then move the data (you pick the method, I like...

Had to manually obfuscate...

Thanks! I will ...

GilaMonster (5/22/2015)

---

And you added two columns to the existing index? Or created a new...

Attached the execution plan.

GilaMonster (5/22/2015)

---

Well then no, the optimiser won't chose it. It's going to look for the most efficient index, if you're creating an index...

Ok Gail,

Here is the execution plan...

Knew that type of answer was coming.

But it's NOT...

Lowell (5/15/2015)

---

i often get a similar error message when i create a new linked server, where i forgot to set the rpc and rpc out to true;

Executed as...

It is running on all the servers. Definitely, the problem is that is TRUE on all but one.

Now, just found this Thread where Paul explains how to turn it on...

Lowell (5/15/2015)

---

pretty sure the misisng pice is the service, if you've toggled both rpc settings in your linked server.

On the Target/linked server, Remote desktop over to it andopen services....it has...

bump... anyone?

SQLRNNR (5/4/2015)

---

I am curious. What are the relative costs of those index seeks? Just gonna skip past that remote query for now because you can't do much with...

Jack Corbett (5/4/2015)

---

There really isn't a way to fix this problem without a code change. The issue is that ALL the data is being brought across the...

TheSQLGuru (5/3/2015)

---

sql-lover (5/3/2015)

---

TheSQLGuru (5/1/2015)

---

sql-lover (5/1/2015)

---

TheSQLGuru (5/1/2015)

---

I didn't read deeply (TL;DR) :), but the first thing I would do is put the query into a sproc on the remote side and...