Finding object names in error message text

Many Adaptive Server error messages print only the logical page number, not the name of the affected table or index. The procedure “How to Find an Object Name from a Page Number” in the most recent version of Troubleshooting and Disaster Recovery explains how to find the table or index name using the logical page number supplied by the error message. You may want to review that section now so that you are familiar with the necessary procedures before an error occurs.

WARNING! The procedure referenced in the preceding paragraph uses the dbcc page command. Use the dbcc page command only as directed. This command is undocumented, nonstandard, and is provided “as is” without any warranty. Sybase Technical Support does not support this command for general use. Although the command syntax is provided for reference, use this command only in the specific diagnostic situations described, and with the specific syntax shown. Failure to do so could cause performance problems and database corruption.