refresh sysdepends

  • Does anyone know a way to refresh the sysdepends metadata. It seems to be inacurate.

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • The only way I ever found that was doing somewhat of a good jobs was to manually alter all the objects (must be a way to automate this but I didn't pursue that).  Basically you make the server recheck the syntax and update sysdepends.

     

    But as far as I know there will always be some degree of inaccurracy so you should not depend on that.

  • It gets out of whack pretty quick, I never depend on it (pardon the pun).

    Google sp_msdependencies to see if it can be of use to you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply