Is the dependency tracker capable of analyzing dynamic SQL?

ejs

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 R

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.