• I missed this one too. I was under the impression that SET SHOWPLAN ALL gave you the actual (not estimated) execution plan without executing the query and returning results.

    From BOL:

    Causes Microsoft® SQL Server™ not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed and provides estimates of the resource requirements for the statements.

    Can anyone shed some light on this?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden