Sometimes it is very hard to finds objects, view or tables used by stored procedure or view.
here is script which is used to find the objects from sql server.
Query Two system tables :
1. sys.objects : to find the object
2. sys.comments : to find the right text.
select obj.name, comm.text from sys.syscomments comm inner join sys.objects obj on obj.object_id = comm.id where comm.text like ‘%your text goes here%’