MSSQLSERVER_2501

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

2501

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

DBCC_NO_SUCH_TABLE_NAME

Message Text

Cannot find a table or object with the name 'NAME'. Check the system catalog.

Explanation

The specified object cannot be found.

Possible Causes

This error can be caused by one of the following problems:

  • The object is not specified correctly.

  • The object does not exist, or the object was dropped before a statement tried to use it.

  • The object might exist, but could not be exposed to the user. For example, the user might not have permissions on the object, or the object is an internal table that could not be seen by a user.

User Action

  • Verify the current database context is correct. For more information, see USE (Transact-SQL).

  • Verify that the table or object name is spelled correctly.

  • Verify the schema name that contains the object. If the object belongs to a schema other than the default (dbo) schema, you must specify the table or object name by using the two-part format schema_name.object_name.

  • Verify that the object exists in the system tables. To verify whether a table or other schema-scoped object exists, query the sys.objects catalog view. If the object is not in the system tables, the object has been deleted, or the user does not have permissions to view the object metadata. For more information about how to view object metadata, see Metadata Visibility Configuration.

See Also

Reference

Catalog Views (Transact-SQL)