This pertains to SQL Server 2000
Do others have the problems that we have in our company, where we have
a field from a table, and need to know all the SQL Server processes
that may change that value? I'm still hoping somebody can tell me of a
tool, or set of queries or something that will document the fields in
the tables and the processes that affect them, along with the values
that it sets. For example:
TableA.FieldA:
sp_InsertNewRec: sets field to Null when new record created
sp_ChangeStatus: sets field to the value of the parameter passed in
tr_LogChanges: sets field to be the current datetime
Maybe we're just too sloppy at my company, but it seems to be fairly
obvious need to have some sort of automated process that can provide
that documentation. With thousands of fields, hundreds of stored
procedures, triggers, DTS's etc..., documenting this information is a
VERY daunting task. Any help at all would be appreciated.
Gary