SQL Server 2008 : find out wich stored procedures writes to certain table -

SQL Server 2008 : find out wich stored procedures writes to certain table -

i trying hunt downwards stored procedure writes table (it needs changed) going through every single stored procedure not route want take. hoping there might way find out stored procedures insert or update table.

i have tried using method (pinal_daves_blog), not giving me results.

notice: stored procedure might not in same db!

is there way or can somehow check procedure/function has made lastly insert or update table.

i hoping kind people here might help me out :)

thank help.

you run trace in profiler. procedure have write table while trace running grab it.

sql-server sql-server-2008 stored-procedures insert sql-update