How to find number of SP's hitting a specific table?

Question

I need a query that shows all stored procedures that are hitting to a specific table.

some kind of internet search perhaps? – Mitch Wheat Dec 09 '15 at 08:26 — Mitch Wheat, Dec 09 '15 at 08:26

score 0 · Answer 1 · answered Dec 09 '15 at 08:27

0

Try this one....

  sp_depends 'dbo.TableName'
  GO

answered Dec 09 '15 at 08:27

rjps12

1 Answers1