How to stop replication in SQL Server 2012 using code

Asked May 02 '17 at 10:35

Active May 02 '17 at 10:40

Viewed 199 times

I want to add column in a table but this message appears:

'Students' table - Unable to modify table. The data definition language (DDL) command cannot be executed at the Subscriber. DDL commands can only be executed at the Publisher. In a republishing hierarchy, DDL commands can only be executed at the root Publisher, not at any of the republishing Subscribers. The schema change failed during execution of an internal replication procedure. For corrective action, see the other error messages that accompany this error message. The transaction ended in the trigger. The batch has been aborted.

edited May 02 '17 at 10:40

TT.

15,774
6
47
88

asked May 02 '17 at 10:35

Alnebras Murtada

1

You can execute the statement to add a column at the Publisher, you don't need to stop the replication per se. – TT. May 02 '17 at 10:40
2

What's your overall goal here? Is it to have an actual different schema at the subscriber than the publisher? – Damien_The_Unbeliever May 02 '17 at 10:44
I was found solution ,execute the procedure sp_removereplication'DatabaseName' – Alnebras Murtada May 04 '17 at 16:50

How to stop replication in SQL Server 2012 using code

0 Answers0