Red Gate forums :: View topic - objects used in dynamic sql
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

objects used in dynamic sql

 Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mulmad



Joined: 03 Nov 2005
Posts: 55
PostPosted: Fri Oct 06, 2006 10:16 am    Post subject: objects used in dynamic sql Reply with quote
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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
PostPosted: Sat Oct 07, 2006 8:16 am    Post subject: Reply with quote
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:
declare @sql varchar(50)
SET @sql='SELECT * from MyTable'
exec sp_executesql @sql

_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group