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 |
|
ammicr
Starting Member
2 Posts |
 Posted - 2003-09-09 : 13:08:48
|
| Our ministry tried to implement merge replication about a month ago. The day after we 'turned it on' we noticed that we weren't able to truncate tables. The error stated (not quoted): 'Truncate Table is not allowed....merge replication'.Any ideas on how to get around this?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-09 : 13:13:21
|
| Instead of TRUNCATE TABLE, use DELETE FROM.Tara |
 |
|
|
ammicr
Starting Member
2 Posts |
Posted - 2003-09-09 : 13:58:54
|
| Thanks - I'll give it a try |
|
|
|
|
|
|
Merge Replication - Truncating Tables