Welcome to the Lounge

MarkTJohnson wrote:

Now, having read Mycroft's post I feel terrible about my post.

MarkTJohnson wrote:

Good to hear

Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

Mycroft Holmes wrote:

(one assumes/hopes that after 2 years the habit should be eliminated)

M.D.V.

If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.

USE MyDatabase

DECLARE @SchemaName nvarchar(128) = 'dbo'
DECLARE @TableName  nvarchar(128) = 'TableWithColumnToRemove'
DECLARE @ColumnName nvarchar(128) = 'ColumnToRemove'
;

SELECT  SCHEMA_NAME(o1.schema_id) + '.' + o1.name ReferencingObject
       ,SCHEMA_NAME(o2.schema_id) + '.' + ed.referenced_entity_name ReferencedObject
       ,c.name ColumnName
       ,o2.type ReferencedObjectType
       ,o1.type ReferencingObjectType
FROM    sys.sql_expression_dependencies ed
JOIN    sys.objects o1 ON ed.referencing_id = o1.object_id
JOIN    sys.objects o2 ON ed.referenced_id = o2.object_id
JOIN    sys.sql_dependencies d ON ed.referencing_id = d.object_id
    AND d.referenced_major_id = ed.referenced_id
JOIN    sys.columns c ON c.object_id = ed.referenced_id
    AND d.referenced_minor_id = c.column_id
WHERE   1=1
    AND SCHEMA_NAME(o2.schema_id) = @SchemaName
    AND o2.name = @TableName
    AND c.name = @ColumnName
ORDER BY ReferencedObject
    ,c.column_id;