Stored Procedure Deferred Name Resolutions

Stored Procedure Deferred Name Resolutions 

 When you create stored procedures the code of the procedure is parsed to ensure that no syntax error exists. If the syntax of the command are correct then the text of the procedure will stored in syscomments  table in the database in which the procedure is being created. 

  The first time the SP is executed the SQL server query processor read the data from the syscomment table and checks whether all the objects referenced in the SP are contained in the database , this process is known as deferred name resolution. because of this deferred name resolution, any object referenced in the SP is not required at the creation time. The object must be there only when SP execute first time. This process allow user to drop and recreate table without having to recompile all the USP.