Finding affected tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tyler Hudson
    #1

    Finding affected tables

    I am attempting to document a sql server 2000 based accounting system.
    Is there any way to see what tables a stored procedure affects
    without diving into the code?



    Regards,

    Ty
    Tags: None
    • Simon Hayes
      #2
      Re: Finding affected tables


      "Tyler Hudson" <tylerh@allpax. com> wrote in message
      news:804fa945.0 403020849.fcf8f 0b@posting.goog le.com...[color=blue]
      > I am attempting to document a sql server 2000 based accounting system.
      > Is there any way to see what tables a stored procedure affects
      > without diving into the code?
      >
      >
      >
      > Regards,
      >
      > Ty[/color]

      You can try sp_depends, although it may not be completely accurate,
      depending on the order in which objects were created.

      Simon


        Comment

        Previous template Next
        Working...