Is the dependency tracker capable of analyzing dynamic SQL?

Is the dependency tracker able to determine dependencies based upon analysis of query plans created through dynamic sql execution (via sp_executesql()).   I specifically am looking for ways of answering the "where used" column or table references for example.


  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi @ejs,

    Very sorry to say that SQL Dependency Tracker doesn't support dynamic SQL. I've +1'd a request we have for this (internal reference DT-740) though we don't have any plans to add this in the immediate future.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Sign In or Register to comment.