<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
<title>Comments on snippet: 'Find sp or table name in all stored procs'</title>
<link>http://snipplr.com</link>
<description>Snipplr comments feed'</description>
<language>en-us</language>
<pubDate>Sun, 19 May 2013 22:42:38 GMT</pubDate>
<item>
<title>hairajeshk said on 12/8/10</title>
<link>http://snipplr.com/view/43820/find-sp-or-table-name-in-all-stored-procs/</link>
<description><![CDATA[ How can I find if particular table is being used in the stored procedure?
How to search in stored procedures?
--Searching for Empoloyee table
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%'
GO
--Searching for Empoloyee table and RateChangeDate column together
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Employee%'
AND OBJECT_DEFINITION(OBJECT_ID) LIKE '%RateChangeDate%'
GO ]]></description>
<pubDate>Wed, 08 Dec 2010 16:45:58 GMT</pubDate>
<guid>http://snipplr.com/view/43820/find-sp-or-table-name-in-all-stored-procs/</guid>
</item>
</channel>
</rss>