Posted by Jack Vamvas on 03/07/06 16:04

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@bastyr.edu> wrote in message
news:1141683757.566950.165430@e56g2000cwe.googlegroups.com...
> 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]