TABLE 1: SP:Recompile EventSubClass Values for Procedure Recompilation
Integer code	Reason for recompilation
1	Schema, bindings, or permissions changed between compilation and execution.
2	Statistics changed.
3	Object not found at compile time, deferred check to runtime.
4	SET option changed in batch.
5	Temporary table schema, binding, or permission changed.
6	Remote rowset schema, binding, or permission changed.