Find references to a column *anywhere* in SQL Server. Uses text search rather than hard dependencies. Originally from http://stackoverflow.com/questions/1883700/in-sql-server-how-can-i-find-everywhere-a-column-is-referenced, answer by Anar Khalilov

FindReferences.sql

SELECT sys.objects.object_id,
  sys.schemas.NAME AS [Schema],
  sys.objects.NAME AS Object_Name,
  sys.objects.type_desc AS [Type]
FROM sys.sql_modules(NOLOCK)
INNER JOIN sys.objects(NOLOCK) ON sys.sql_modules.object_id = sys.objects.object_id
INNER JOIN sys.schemas(NOLOCK) ON sys.objects.schema_id = sys.schemas.schema_id
WHERE sys.sql_modules.DEFINITION COLLATE SQL_Latin1_General_CP1_CI_AS LIKE '%.PartyTitleTxt%' ESCAPE '\'
ORDER BY sys.objects.type_desc,
  sys.schemas.NAME,
  sys.objects.NAME