Posted by KR on 03/07/06 00:22

I don't know if the title for the subject is appropriate here, anyway
here goes:

This process was set up by someone and I have inherited it. I have a
sql2000 database that has about 13 tables that get populated with data
from 3 different databases. I have identified where each of this data
comes from, and the stored procedures that do the updates, inserts, and
deletes, and the jobs that run these stored procedure to do the
updates, except for one table. The updates for all the other tables
are done through scheduled jobs. For the one table I know where the
data comes from and the stored procedure that needs to run to do the
update on the table, however I have not been able to identify the
process that runs the stored procedure.

I am hoping that someone can give me a clue as to how to find out where
a stored procedure is being used - or any other hint as to how I could
go about finding out how this table gets updated.

Thanks
KR

[Back to original message]