Symptom
After drop trigger. The dbcc checkcatalog reported the following corruption.
dbcc checkcatalog (mydb)
go
Checking mydb: Logical pagesize is 8192 bytes
Msg 15009, Level 16, State 1:
Server 'myserver', Line 1:
Table Corrupt: Trigger (id 71965714) for table 'ticket_rules' was not found in sysobjects.
Msg 2513, Level 16, State 12:
Server 'myserver', Line 1:
Table Corrupt: Object id 71965714 (object name = 71965714) does not match between sysobjects and sysconstraints
Read more...
Environment
SAP ASE 16.0
Product
Keywords
CR825879, CR#825879, Msg 15009, Msg 2513, Table Corrupt: Trigger, does not match between sysobjects and sysconstraints , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview