Searching for table names using regexp

[codefox]

I have a SQL server database with a number of tables and several asp pages using some of those tables. I'd like to know which tables are used by the asp pages. Any ideas on how I could do that? Also, should I use regular expressions to achieve this. I'm not used to regexp.

Thanks.