When a Stored procedure is created it is syntactically
checked and if there is no error then SP is created. Sp is stored on the
SYS.SQL_Module.
See in the current database Emp table is not there. But
still the SP is created successfully.
See the Stored Procedure
When we executing this Sp we will get the error
Getting Error like “Invalid Object Name”
This is the run time error.
This Scenario is known as Deferred Name Resolution.
