Sometimes you have situation, where in you want to figure out which function a particular word / object is used in. You can use the following query for this purpose. This query is useful if you want to search in which function a particular table is being used. SELECT OBJECT_NAME(id), TEXT FROM syscomments WHERE [text] LIKE '%proc_name%' -- AND OBJECTPROPERTY(id, 'IsProcedure') = 1 You can also use this query for the purpose SELECT * FROM sysobjects WHERE name LIKE '%email%'