-- Original behavior

:CONNECT SQL2K12-SVR2
DBCC TRACEON(9485, -1);
GO

:CONNECT SQL2K12-SVR1
-- Check estimates vs. actual
USE [Credit];
GO

SELECT  c.[charge_no],
        c.[member_no],
        c.[provider_no],
        c.[category_no],
        c.[charge_dt],
        c.[charge_amt],
        c.[statement_no],
        c.[charge_code]
FROM    [dbo].[charge] AS c
INNER JOIN [SQL2K12-SVR2].Credit.dbo.charge AS rc
        ON c.[charge_no] = [rc].[charge_no]
WHERE   [rc].[member_no] = 7894
OPTION  (RECOMPILE);
GO


:CONNECT SQL2K12-SVR2
DBCC TRACEOFF(9485, -1);
GO


:CONNECT SQL2K12-SVR1
USE [Credit];
GO

SELECT  c.[charge_no],
        c.[member_no],
        c.[provider_no],
        c.[category_no],
        c.[charge_dt],
        c.[charge_amt],
        c.[statement_no],
        c.[charge_code]
FROM    [dbo].[charge] AS c
INNER JOIN [SQL2K12-SVR2].Credit.dbo.charge AS rc
        ON c.[charge_no] = [rc].[charge_no]
WHERE   [rc].[member_no] = 7894
OPTION  (RECOMPILE);
GO
