Microsoft SQL Server 2014 Unleashed

Deferred Name Resolution

In SQL Server 2014, 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. One 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 25.7). The other exception is when the stored procedure references an object through a linked server connection. The linked server must exist and be accessible, as well as ...