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 ‘%Column_Name%’ ESCAPE ‘\’ ORDER BY sys.objects.type_desc, sys.schemas.name, sys.objects.name Replace Column_Name with intended search string.

What I did to get it sorted was by installing the driver below: http://www.microsoft.com/download/en/confirmation.aspx?id=23734