Problem with dependencies when change a table

• Teresita Castro

  SSCommitted

  Points: 1568

  More actions

  October 10, 2007 at 5:46 pm

  #180076

  Hi

  I made a change to a table structure, I add a new field, but when I go to (right click) +All task + display dependencies, I don't see the sp relate with this table anymore.

  How can I see then again?

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  October 10, 2007 at 5:56 pm

  #741031

  After you've changed the schema all procedures used it must be recompiled.

  Their binary code becomes irrelevant, and so their dependencies.

  When those SPs will be executed next time optimiser will evaluate the new schema and establish dependencies if it's possible.

  If SP will fail compilation against the new schema no dependencies will be established.

  _____________
  Code for TallyGenerator