Error 2501

Troubleshooting SQL Server

Troubleshooting

Error 2501

Severity Level 16
Message Text

Could not find table named '%.*ls'. Check sysobjects.

Explanation

Usually some form of corruption in the database causes this error. This often happens when a table is being dropped and a serious error occurs that causes the drop to fail.

Action

Executing DBCC CHECKDB and DBCC CHECKCATALOG can indicate other problems in the database. Restore your database from backup or contact your primary support provider for assistance.

You may also be able to use the bcp utility to copy out other tables. But because this problem is often caused by other problems in the database, problems can occur when you copy out other tables.

See Also

bcp Utility

BULK INSERT

DBCC CHECKDB

DBCC CHECKCATALOG

Errors 2000 - 2999

Reporting Errors to Your Primary Support Provider