SELECT
DISTINCT "TableName" = so.name, "ColumnName" = sc.name
FROM
sysobjects so with (nolock) INNER JOIN syscolumns sc with (nolock)
ON so.id = sc.id
WHERE so.type = 'u'
AND sc.name Like '%EnterFieldName%'
ORDER BY
so.name
Every now and again, I try to talk about "your apples." In fact, probably about 64 days out of the year, I talk about "your apples." I tell the world about the wonders of "your apples" and how the heavens probably parted with force and vigor to give all of us a glimpse of "your apples." You know, there are times when I go down to the cornerstore to pick up a few newspapers and a Coca-Cola. I like to think about an image of "your apples" on the cover of the local newspaper. I think it's because by "your apples," I mean "Al Gore."