What are the challenges you face when working across database platforms? Take the survey

objects used in dynamic sql

mulmadmulmad Posts: 94
edited October 7, 2006 3:16AM in SQL Dependency Tracker
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.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1

    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
Sign In or Register to comment.