Visualizes SQL Server object dependencies.
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.
- Posts: 55
- Joined: Thu Nov 03, 2005 1:27 pm
Indeed, this is something for us to look at. It doesn't appear that Dependency Tracker looks inside quoted strings for dependent objects, ie
- Code: Select all
declare @sql varchar(50)
SET @sql='SELECT * from MyTable'
exec sp_executesql @sql
- Posts: 6590
- Joined: Mon Aug 23, 2004 9:48 am
Return to SQL Dependency Tracker 2
Who is online
Users browsing this forum: No registered users and 0 guests