Microsoft® SQL Server 2012 Unleashed

Deferred Name Resolution

In SQL Server 2012, the objects referenced within a stored procedure do not have to exist at the time the procedure is created. SQL Server creates the stored procedure and the references to missing objects are validated when the stored procedure is executed. No error or warning message is issued about the missing objects when the stored procedure is created. The only exception is when a stored procedure references another stored procedure that doesn’t exist. In that case, a warning message is issued, but the stored procedure is still created (see Listing 24.7).

LISTING 24.7 Procedure Name Resolution During Stored Procedure Creation

Click here to view code image

create proc p2asexec p3go/* outputThe module 'p2' depends ...