deferred name resolution

deferred name resolution determines whether deferred name resolution is applied globally to server connections.

Summary Information

Default value

0 (disabled)

Range of values

0 to 1

Status

dynamic

Required role

System administrator

Configuration group

Query tuning

When deferred name resolution is active (set to 1), deferred name resolution is applied globally to all server connections; all procedures you create in the server are created using deferred name resolution.

Therefore, the stored procedures are created without resolving the objects referenced inside the stored procedure, postponing object resolution processing to the execution time. See Transact-SQL Users Guide > Using Stored Procedures.