Post reply

dependencies on a table.

  • June 1, 2010 at 5:31 pm

    #387054

    Hello All,

    I have an interesting question.

    I have a table, I just want to if this table gets updated manually,

    or does it have any SP or Job that updates the table or the source from where the table gets the data.

    I tried right click on table and view dependencies and its giving me the SP and views that depend on that table. but It doesn't give any job related information or any other information.

    Its an urgent issue, Can some one help me on this.

    thanks in advance.

  • June 1, 2010 at 11:42 pm

    #1175104

    Dependency info is only stored (poorly) for objects in the same database. You'll have to check for job dependencies manually (by checking the definition of the jobs)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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