title: Easy way to search a table used by stored procedure and views?
body: <p>I have a few tables in SQL server 2008. I want to find a list of all the stored procedures and views that are using this table. I am new to SQL server, I think there has to be an easy way rather than opening each view and stored procedure and search for the table name. Thanks</p>