I don't quite understand. But are you saying we can have second and even third one by choosing Other data source from the Server type? Can you please explain me...

Pardon me if I misunderstood your question. My understanding is that you can have only one linked server per each remote server. In other words, the linked server name has...

I don't see any of those.

According to your recommendation, I doublechecked the linked server is set properly. and I also ran that command. No difference. Any other idea please?

When I also ran Perfmon twice; one time with the sql jobs on and the other with the jobs off. I saw huge difference in I/O Disk Queue. The queue...

Definitely I will. Thank you so much.

Thank you John.

Hi John,

Additional question. Was the Duration column a right place to look into when comparing performance? Is there any other columns that could tell me the difference? It seems like...

No Error msg. Simply none of them get the email.

Oh I Found something on the server. I see three of these programs installed.

Microsoft .NET Framework 1.1 Configuration

Microsoft .NET Framework 1.1 Wizards

Microsoft .NET Framework 2.0 Configuration

I'm sorry. But I don't know where to go to check the version.

"Library not registered" this is it. no other explanation.

My first reaction was "what the heck is parameter sniffing !!!". Believe it or not, it was becacuse of it. Thank you so much guys.

ooops... Never mind. I should have given it more time. After I came back from jogging, it was all done. 5 million records can take time. Thank you anyway.

Both worked perfect. Thank you guys.