Cannot truncate table because it is published for replication or enabled for Change Data Capture

Question

Cannot truncate table because it is published for replication or enabled for Change Data Capture

Welsh Corgi

SSC Guru

Points: 116520
More actions
July 8, 2015 at 8:21 am

#302214

I get the following error message when a job calls a Stored Procedure that TRUNCATES a Table:
Cannot truncate table 'CombinedSurveyData' because it is published for replication or enabled for Change Data Capture
Is my only option to change the TRUNCATE to DELETE?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Yes.

Well, you could drop the replication, truncate the table and then reconfigure and initialise the replication, but I doubt that's a feasible option.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Thanks Gail! 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

saurabh.x.sinha Ten Centuries Points: 1125 More actions · Answer 3

Please refer : Solution here

Thanks

Saurabh Sinha

http://saurabhsinhainblogs.blogspot.in/[/url]

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

saurabh.x.sinha (8/28/2016)
Please refer : Solution here
Thanks
Saurabh Sinha
..url removed..

This sure looks a LOT like an attempt to pump your blog. This question is over a year old and the link you provided is not valid.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/