Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    1

    Unanswered: Automated SQL documenation?

    I am an intern at a university and we are looking for a way to automatically document tables, queries, etc. ColdFusion is the platform used, and SQL Server 2000. Is there a way to have the documentation performed that will capture tables, constraints, etc.? I have found some, but so far, none are working. Please help if you can!!!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    SQLDMO would be my first choice, SQL-EM (Enterprise Mangler) would be a tolerable interface if you don't want to code your own.

    -PatP

  3. #3
    Join Date
    Jul 2004
    Posts
    60
    ditto all 'dat

    +

    there are LOTS of sp_helpthisthatandwhatever you can use to get all that info if you're not a VB guy.
    same stuff EM ends up using to populate its forms, but i like it mo' betta.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What kind of documentation do you want? Relationships and dependencies and such? Who is the intended audience and what will they be doing with the information?
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I made it a habit to create data diagrams for every db I'm working with.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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