There's a maintenance plans folder in Enterprise manager, you look through that. Check to see if any of your maintenance plans have the check database integrity task. If any do, check the task, see if the check box I mentioned is checked.

You can get procedure definitions with sp_helptext, that can be inserted into a table which you can then query.