Ars Technica

SQL Server - Linked Servers going back 3 layers - how does query execution work?

When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
Ars Technica

SQL Server: linked server connection drops, sp doesn't notice?

I don't know if we have a config incorrect or what.<BR><BR>We have a stored procedure that does some selects to import data from tables and views on a linked SQL Server.<BR><BR>Lately, every once in a ...
MCPmag

Top 12 Features of SQL Server 2012

Microsoft has introduced SQL Server 2012 to the world and it's time for IT professionals to start to come to speed on what's new. Microsoft has introduced SQL Server 2012 to the world and it's time ...