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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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
    
Sign In or Register to comment.