How table is getting data

Question

Hi,

I have a table which gets data from  procedure  in sql server ,but i need to know which sp is inserting data into this table.

how do i find which procedure is inserting data into the table.

Tried looking into all the procedures but not helpful.

Thanks

Answer 1

Hi there,

Take a look on this DMV:

sys.system_sql_modules

Answer 2

Hi Knewsql,

According to your description, you need to know which stored procedure was used to insert data into your table, right?

You can list all the stored procedure which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results. And then you can check which stored procedure is used to insert data into your table.

Reference
http://blog.sqlauthority.com/2006/12/10/sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure/
http://stackoverflow.com/questions/7272157/how-to-identify-all-stored-procedures-refering-a-particular-table

Regards,

---

Charlie Liao
TechNet Community Support