Symptom
- When run 'drop index' to drop a index named like 'repl_***', you got Msg 3756:
Msg 3756, Level 16, State 1:
You cannot manually drop an index for replication. Either turn off replication on the column, or run DBCC REINDEX. - You may run the command below to check if there is table or database replication exist:
1> use <db_name>
2> go
1> sp_reptostandby <db_name>
2> go
1> sp_setreptable <table_name>
2> go
1> sp_setrepcol <table_name>, <column_name>
2> go
Read more...
Environment
SAP Adaptive Server Enterprise 15.7 and earlier
Product
Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.