What are the consequences of the sys.sql_dependencies Catalog View Not Being Updated
If I have two trivial stored procedures, created like so: create procedure root as select 1 go create procedure dependant as exec root go (Where dependant depends on root). When I check the sys.sql_dependencies table for the second procedure, I see an entry (as i would expect). If, however, I add the dependant procedure first, I ...