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.