SELECT c.name AS 'ColumnName', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%changeSignOffStaff%' ORDER BY TableName, ColumnName;
Rererence
https://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name