How can we help you today?

How can we help you today?

objects used in dynamic sql

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.

mulmad October 06, 2006 05:16

0

Comments

1 comment

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&#40;50&#41;
SET @sql='SELECT * from MyTable'
exec sp_executesql @sql
```
Brian Donahue October 07, 2006 03:16

0

Add comment

Please sign in to leave a comment.