Q:

SQL Server 2000: search through out database

Some how some records in my table are getting updated with value of xyz in a certain column. Out of hundred of stored procedures, functions, triggers, how can I determine which code is doing this action. Is there a way to search through the database some how through each and every script of the code?
Please help.

A:

One approach is to check syscomments  

Contains entries for each view, rule,
  default, trigger, CHECK constraint,
  DEFAULT constraint, and stored
  procedure within the database. The
  text column contains the original SQL
  definition statements..

  e.g.  select text from syscomments

If you are having trouble finding that literal string, the values could be coming from a table, or they could be being concatenated within a routine. 
Try this
Select text from syscomments
where CharIndex('x', text) > 0 
and CharIndex('y', text) > 0 
and CharIndex('z', text) > 0

That might help you either find the right routine, or further indicate that the values are coming from a table. 

