Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venug
Starting Member
3 Posts |
 Posted - 2013-01-23 : 01:57:05
|
| 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
52326 Posts |
Posted - 2013-01-23 : 02:05:10
|
| hmm...thats a bit strangeIs it using TRUNCATE or DELETE FROM statement?If latter, does it have a trigger in place?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
venug
Starting Member
3 Posts |
Posted - 2013-01-23 : 02:11:44
|
| No triggers on the table,neither being used for reference in any table. |
|
|
|
ovc
Starting Member
35 Posts |
Posted - 2013-01-26 : 12:40:53
|
| 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. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-01-29 : 11:13:37
|
| 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? |
|
|
|
|
|
|
Truncation of table is stopping replication