I have restored a database in another server. I don't want any of the transactional subscriptions of the former database. I already called
exec sp_removedbreplication 'MyRestoredDB' go
exec sp_cleanupdbreplication go
exec sp_replicationdboption 'MyRestoredDB','Publish','False',1 go
But when I try
truncate table dbo.sample
I get the following error:
Msg 4711, Level 16, State 1, Line 7 Cannot truncate table 'sample' because it is published for replication or enabled for Change Data Capture.
I verified that the database isn't enabled for CDC. What else I can do to perform the truncate? Delete isn't an option for reasons not relevant to the question.