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 |
|
TSharp
Starting Member
9 Posts |
 Posted - 2008-07-01 : 10:32:13
|
| We have a script to delete data from a select number of tables, then a DTS package is ran to transfer data from a laptop to our server. This process seems to work fine. The problem we are running into is the Replication to the Subscriber does not work. We are currently using SQL Server 2000 and have Merge replication setup. We did verifiy the script to delete the data from the tables is replicated, but for some reason when appending data back to the tables it does not work. (No data is transfered at all, and as far as I can tell no errors occur)I am not even sure where to start looking to find the problem, any help/suggestions would be greatly appreciatedThanksTsharp |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 10:44:33
|
| Are you using delete or truncate to delete datas? Truncate doesn't get replicated automatically in SQL 2000. Look at Replication monitor and job status. |
 |
|
|
TSharp
Starting Member
9 Posts |
Posted - 2008-07-01 : 11:27:57
|
| The script to delete the data has delete from tableOne etc. therefore we are using the delete method... (I am not sure what the Truncate method is) As far as the Replication Monitor and job status we did not see any activitiy, it was like it was not aware of the data being inserted. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 12:02:43
|
| "As far as the Replication Monitor and job status we did not see any activitiy, it was like it was not aware of the data being inserted."What do you mean? Did you get any error? |
|
|
|
TSharp
Starting Member
9 Posts |
Posted - 2008-07-01 : 12:42:32
|
| no, we did not get an error. |
|
|
|
TSharp
Starting Member
9 Posts |
Posted - 2008-07-07 : 13:20:33
|
| If I was doing the above in Access, part of the process would be to compact and repair the database. I noticed there is a DBCC DBReindex Maintenance statement, would something like this need to be part of the process? I also noticed the MSMerge_Tombstone table contains information on deleted rows to be propagated to other Subscribers, is there something I can check/look at/run to ensure this table is ok?Any suggestions/help would be greatly appreciatedThanksTsharp |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-07 : 23:32:31
|
| Reindex is not necessary for deleting process, you can do it during off hours. |
|
|
|
|
|
|
Replication problem when use DTS package