SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

venug
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.

Regards.

visakh16
Very Important crosS Applying yaK Herder

India
52317 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
http://visakhm.blogspot.com/

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

venug
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

ovc
Starting Member

Romania
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

russell
Pyro-ma-ni-yak

USA
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  
 New 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