objects used in dynamic sql

Visualizes SQL Server object dependencies.

objects used in dynamic sql

Postby mulmad » Fri Oct 06, 2006 10: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.
mulmad
 
Posts: 55
Joined: Thu Nov 03, 2005 2:27 pm

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

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
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 10:48 am


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron