Results 1 to 3 of 3

Thread: Database Audit

  1. #1
    Join Date
    Aug 2004
    Location
    Manchester
    Posts
    21

    Unanswered: Database Audit

    Is there any query that can be run to determine which queries use which tables, the names of all the tables in a db and there relationships.

    If anyone has anything similar that could be adapted or any site links that may be useful that would be great also.

    I don't really know where to start but my database has so many queries and table and I need to clear some as they may not still be needed.

    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    maybe this helps.

    confess that i haven't had a chance to play with it yet - comes from a link someone posted here a couple of days ago ...the whole site is worth exploring: some good stuff there.

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Aug 2004
    Location
    Manchester
    Posts
    21

    Thanks

    It's going to be a long process as i've got loads of queries tables etc but it will definately help with which stuff is still in use.

    The website looks really useful

    Cheers.

Posting Permissions

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