Export (0) Print
Expand All
Expand Minimize

MSSQLSERVER_2501

Product Name

SQL Server

Product Version

10.50

Product Build Number

 

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.

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.

  • 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. For more information about schemas, see User-Schema Separation.

  • 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft