The text of all stored procedure, triggers, constraints, and rules are stored in the SYSCOMMENTS table. You can search its Text column for the phrase that you're interested in.

SELECT OBJECT_NAME(id) FROM syscomments WHERE text LIKE '%authors%'

-Mike