Since procedures created using deferred_name_resolution dependency information are created at execution, a message is raised when sp_depends executes a procedure created with deferred_name_resolution but not yet executed:
sp_depends p ---------- The dependencies of the stored procedure cannot be determined until the first successful execution. (return status = 0)
After the first successful execution, the dependency information is created and the execution of sp_depends returns the expected information.
For example:
set deferred_name_resolution on -----------------create procedure p as select id from sysobjects where id = 1sp_depends p ------------ The dependencies of the stored procedure cannot be determined until the first successful execution.(return status = 0)exec p
id ----------- 1(1 row affected)(return status = 0)sp_depends p ----------------The object references in the current database. object type updated selected ---------------------------- ------------------------ -------------- ---------------- dbo.sysobjects system table no no(return status = 0)
