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

A couple of things you could try are:
1)Run a sql script like :

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%myTableDef.ColDEf%'
AND ROUTINE_TYPE='PROCEDURE'
which will allow you to identify all sps referencing this column name
For example, is there another stored proceure , executing this stored
procedure
2)Is the table updated remotely.
3)Add a column in the table, with date type default value = "GETDATE()".Then
use SQL Profiler to capture the events around the update tiem

--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm


"KR" <kraman (AT) bastyr (DOT) edu> wrote

Thanks! I will try that.

KR