monitor
#monitor#2020

2020

Product Name Event ID 2020 Event Source MSSQLSERVER Component SQLEngine Symbolic Name Message Text The dependencies reported f

Product

Name

Event ID

2020

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

Message

Text

The dependencies reported for entity ”%.*ls” do not include references to columns. This is

either because the entity references an object that does not exist or because of an error in

one or more statements in the entity. Before rerunning the query, ensure that there are no

errors in the entity and that all objects referenced by the entity exist.

The

system function will report any column-level dependency

for schema-bound references. For example, the function will report all column-level

dependencies for an indexed view because an indexed view requires schema binding. However,

when the referenced entity is not schema-bound, column dependencies are reported only

when all statements in which the columns are referenced can be bound. Statements can be

successfully bound only if all objects exist at the time the statements are parsed. If any

statement defined in the entity fails to bind, column dependencies will not be reported and the

column will return 0. When column dependencies cannot be resolved,

error 2020 is raised. This error does not prevent the query from returning object-level

dependencies.

Expand table