Hi Johan,

yes, I had a look at that and now I understand.

Here's a way to reproduce:

On connection 1, execute the following:

[font="Courier New"]CREATE PROCEDURE dbo.TestProc

AS

INSERT #t1

SELECT 1 AS N;

GO

CREATE TABLE #t1(N...

Thank you for your response, Johan, but I'm really looking at how to generate a duplicate plan because of a difference in the optional_spid column, not the SET options.