Consulta SQL para encontrar la columna [field_name] en todas las tablas de una BD en MS SQL Server.

MS_SQL_Server_find_field_table.sql

SELECT  sysobjects.name AS table_name, syscolumns.name AS column_name,
           systypes.name AS datatype, syscolumns.LENGTH AS LENGTH
FROM       sysobjects INNER JOIN
               syscolumns ON sysobjects.id = syscolumns.id INNER JOIN
               systypes ON syscolumns.xtype = systypes.xtype
WHERE     (sysobjects.xtype = 'U') 
                and (UPPER(syscolumns.name) like upper('%field_name%'))
ORDER BY sysobjects.name, syscolumns.colid