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 (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 Chapter 17, “Using Stored Procedures,” in the Transact-SQL Users Guide
