Consider this scenario where you have a linked server from one SQL server to another SQL Server. Both the SQL Servers are SQL Server 2008 SP2 on Windows 2008. Say the two SQL Servers are Server A and Server B. Linked server from Server A to Server B is ...read more