objects used in dynamic sql

Visualizes SQL Server object dependencies.

objects used in dynamic sql

Postby mulmad » Fri Oct 06, 2006 9:16 am

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

Postby Brian Donahue » Sat Oct 07, 2006 7:16 am


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
Brian Donahue
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