Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Truncation of table is stopping replication
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

3 Posts

Posted - 01/23/2013 :  01:57:05  Show Profile  Reply with Quote

When a table which is not involved in replication is truncated its stopping the replication activity.

Please advice.


Very Important crosS Applying yaK Herder

52326 Posts

Posted - 01/23/2013 :  02:05:10  Show Profile  Reply with Quote
hmm...thats a bit strange
Is it using TRUNCATE or DELETE FROM statement?
If latter, does it have a trigger in place?

SQL Server MVP

Edited by - visakh16 on 01/23/2013 02:06:33
Go to Top of Page

Starting Member

3 Posts

Posted - 01/23/2013 :  02:11:44  Show Profile  Reply with Quote
No triggers on the table,neither being used for reference in any table.
Go to Top of Page

Starting Member

35 Posts

Posted - 01/26/2013 :  12:40:53  Show Profile  Reply with Quote
which type of replication are you using? The thing is truncate does not log the "delete rows" in the database log file. That is why there might occur some inconsistencies and the replication stops. Try to use delete from. This should not cause this issue, if I am assuming right.
Go to Top of Page


5072 Posts

Posted - 01/29/2013 :  11:13:37  Show Profile  Visit russell's Homepage  Reply with Quote
run a trace. i bet it's something else.

you can't truncate a replicated table, and a truncate of a table not part of the publication shouldn't have any effect.

why do you think that the truncate is causing replication to stop?
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000