InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:54:15 GMT20http://www.sqlservercentral.com/Forums/Topic18917-124-1.aspxOverall I think this is a very good start.One thing to keep in mind is that proc names can contain embeaded underscore characters (i.e. update_company), which when used in a LIKE match can cause problems unless they are properly escaped (i.e. _ becomes [_]). It is also valid to include statement terminators immediately after the proc name (i.e. exec run_me; )With these two points in mind, I have updated the ad-hock query WHERE comparision to look like: WHERE #T1.ProcText LIKE '%' + Replace(T2.DependOnProc,'_','[_]') + '[' + char(9)+ char(10)+ char(13)+ char(32) + char(59) + ']%'(be sure to add back in the plus characters for string concatination between each of the substring elements above -- looks like the forum software doesn't like this...) Thu, 18 Dec 2003 08:58:00 GMTmeknamhttp://www.sqlservercentral.com/Forums/Topic18917-124-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/spopovski/findingrealdependencies.asp>http://www.sqlservercentral.com/columnists/spopovski/findingrealdependencies.asp</A>Fri, 05 Dec 2003 00:00:00 GMTs_popovski