Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2007
    Location
    Auburn, CA
    Posts
    4

    Angry Unanswered: Generate sysdepends list

    I can't seem to find a way of gettng a list of the view/stored procedure/UDF dependencies by object. Any ideas?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What program are you using to do this?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2007
    Location
    Auburn, CA
    Posts
    4

    Red face List of all Dependencies in my SQL Server DB

    I am using ASP and vbscript to access the list and it is not retreiving all of the dependencies.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Microsoft SQL doesn't guarantee 100% coverage for sysdepends. There will be some cases where you won't have a row that should be there.

    -PatP

  5. #5
    Join Date
    Feb 2007
    Location
    Auburn, CA
    Posts
    4

    Talking reading sysdepends

    Thanks Pat. I found shrinking the database brings newer dependencies into the list. Odd.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If a DDL script creates an object that references an object that does not yet exist (for instance, it is created later on...), then the first object will be created anyway but an entry will not be added to sysdepends. It should generate a warning to notify you of this.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Feb 2007
    Location
    Auburn, CA
    Posts
    4

    Talking Create Underpinings first

    I create any dependencies a new store procedure, UDF or view needs first before creating the new piece to avoid the errors associated with referenced unknowns. Thanks for the tip.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •