TABLE 1: Captured Trace Events Showing Procedure Recompilations
Event Class	Text
SP:Starting	GetLocations
SP:StmtStarting	SET concat_null_yields_null OFF
SP:StmtStarting	SELECT Publisher_Location = city + ', ' + state + ', ' + country FROM pubs..publishers
SP:Recompile	GetLocations
SP:StmtStarting	SELECT Publisher_Location = city + ', ' + state + ', ' + country FROM pubs..publishers
SP:StmtStarting	SET concat_null_yields_null ON
SP:StmtStarting	SELECT Employee_Location = city + ', ' + region + ', ' + country FROM Northwind..employees
SP:Recompile	GetLocations
SP:StmtStarting	SELECT Employee_Location = city + ', ' + region + ', ' + country FROM Northwind..employees
SP:Completed	RecompProc