{"id":93,"date":"2011-08-14T10:30:00","date_gmt":"2011-08-14T15:30:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=93"},"modified":"2023-07-26T12:32:32","modified_gmt":"2023-07-26T17:32:32","slug":"locate-stored-procedures-related-to-a-table","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=93","title":{"rendered":"Locate Stored Procedures Related To a Table"},"content":{"rendered":"<p><span style=\"font-family:courier new;\"><span style=\"color:#009900;\">&#8212;-Option 1<\/span><br \/>\n<br \/>SELECT DISTINCT so.name<br \/>\n<br \/>FROM syscomments sc<br \/>\n<br \/>INNER JOIN sysobjects so ON sc.id=so.id<br \/>\n<br \/>WHERE LOWER(sc.TEXT) LIKE <span style=\"color:#ff0000;\">&#8216;%name%&#8217;<\/span><br \/>\n<br \/><span style=\"color:#009900;\">&#8212;-Option 2<\/span><br \/>\n<br \/>SELECT DISTINCT o.name, o.xtype<br \/>\n<br \/>FROM syscomments sc<br \/>\n<br \/>INNER JOIN sysobjects o ON sc.id=o.id<br \/>\n<br \/>WHERE LOWER(sc.TEXT) LIKE <span style=\"color:#ff0000;\">&#8216;%name%&#8217;<\/span><\/span><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8212;-Option 1 SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id WHERE LOWER(sc.TEXT) LIKE &#8216;%name%&#8217; &#8212;-Option 2 SELECT DISTINCT o.name, o.xtype FROM syscomments sc INNER JOIN sysobjects o ON sc.id=o.id WHERE LOWER(sc.TEXT) LIKE &#8216;%name%&#8217;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[50,54],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/93"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=93"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/93\/revisions"}],"predecessor-version":[{"id":180,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/93\/revisions\/180"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=93"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=93"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=93"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}