optimize temp table resolution

optimize temp table resolution allows stored procedures that reference temporary tables created outside the procedure to not require recompiling for each execution. 

Summary Information

Default value 0 (off)
Valid values 0 (off), 1 (on)
Status Static
Display level Comprehensive
Required role System administrator
Configuration group Query Tuning

Trace flag 299 previously supported this functionality.