In ASE 16.0 and in the documentation - if an object bound using dbcc trune(des_bind, dbid, object) -- altering a trigger should give an error:
Msg 8242, Level 16, State 1:
Server 'myserver', Line 2:
The table 'z1' in database 'mydb1' is bound to metadata cache memory. Unbind the table and retry the query later.
However, in ASE 15.7 - this process works with no errors given:
dbcc tune(des_bind, 4, a1)
alter table a1 disable trigger
Warning: trigger 'SYB_DELETE' is already disabled.
alter table a1 enable trigger
Enabling trigger 'SYB_DELETE'.
Enabling or disabling a trigger, does not cause the expected message.
SAP Adaptive Server Enterprise 15.7
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis 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.