objects used in dynamic sql

mulmad

It would be nice if objects used in dynamic sql inside other objects (fx a dynamic sql string inside a stored procedure) would be listed in the dependency lists.

Brian Donahue

Hello,

Indeed, this is something for us to look at. It doesn't appear that Dependency Tracker looks inside quoted strings for dependent objects, ie

declare @sql varchar(50)
SET @sql='SELECT * from MyTable'
exec sp_executesql @sql