<div>
<div class="content wysiwyg-content">
How can I find the list of &nbsp;stored procedures which are using a certain table in database?<br />
I have 100 SPs in one database and I am looking for the SPs which are using a table called&quot;Patients&quot;.. Is there a system table that has this kind of information in SQL server 2005 so that I don;t have to open up each SP one by one?<br />

</div>
</div>


How can I find the list of  stored procedures which are using a certain table in database?
I have 100 SPs in one database and I am looking for the SPs which are using a table called"Patients".. Is there a system table that has this kind of information in SQL server 2005 so that I don;t have to open up each SP one by one?


System table and Stored Procedure

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.