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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2010-04-28 : 04:28:07
|
| Hi there,I have a database that's replicated (transactional replication). One of the tables that I've not yet replicated is truncated periodically and updated data is imported from another database.I've heard there may be problems replicating this table as the replication can't track changes with truncate.Does anyone know if will I have any problems adding this article to replicated database that uses transactional replication?Thanks for any help |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-28 : 08:25:41
|
| You won't have any problems adding the article, but the truncate will fail if the table is replicated. Either switch to delete instead of truncate or, if the table is only changed when it's truncated and reloaded, consider not making it part of the transactional replication, but adding a snapshot replication publication with just this one table and a snapshot scheduled for just after it is reloaded.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
truncate with replication