3418867 - SQL error 22979: The unique index '<table_name>~0' on table '[<schemaname>].[<table_name>]' is used by Change Data Capture - NetWeaver

• SQL error 22979: The unique index '<table_name>~0' on table '[<schemaname>].[<table_name>]' is used by Change Data Capture. 
• The constraint using this index cannot be dropped or disabled.
• <table_name>~0 could not be removed Table <table_name> (Error adjusting the database) Table <table_name> was not activated.

SAP NetWeaver on MS SQL server 2008 and higher.

SQL error 22979,Change Data Capture , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem