I am having problems with sp_depends, it says that my database is invalid for the operation
<p>So i have this database called crm and i need to select a list of all the stored procedures that depend on a specific table/column.
I did some research and i learned about sp_depends, i tried to execute but it reports me and error.
Here's the code:</p>

<p><code>EXEC sp_depends @objname = 'TCdPost'</code></p>

<p>TCdPost stands for a column that contains the postal code.
As i execute the query i get an error that says:</p>

<p><code>The object 'TCdPost' does not exist in database 'crm' or is invalid for this operation.</code></p>

<p>Does anyone know what causes this error or some better ways to select all the stored procedures that depend on a table/column?</p>

<p>Im using SQL Server 2008 R2</p>

<p>Thank you.</p>