• Sorry Jeff, misunderstood!

    Just to run a sproc you can of course edit it to look like:

    SET @Param1 = 'somevalue';

    SET @SQLString = N'EXEC [db].dbo.

    ' + @Param1

    EXECUTE sp_executesql @SQLString

    But I dont think that will have the desired effect on how the plans are stored and utilised.

    'Only he who wanders finds new paths'