>>Is there a way in SQL Server Management Studio to find tables with a specific field name?
>

>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
>WHERE TABLE_NAME IN (
>        SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS
>        WHERE COLUMN_NAME='My Field'
>)

No need of WHERE IN, INFORMATION_SCHEMA.COLUMNS has also TABLE_NAME :-)

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='My Field'