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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-12 : 08:38:06
|
| Gary writes "have a SQL Server database which has replication on a table set up on. It has a Publication which filters the records in SQL. It has 3 subscriptions which are all Access databases. This is the problem. The replication is set to update the tables in the access databases every 15 minutes. This works fine except that one of the tasks in the distribution agent for one of the databases always reports 'no available transaction'. I have deleted all three subscriptions and recreated them again. The same happens every time. Just checked SQLServer again 2 of the access databases replicated tables have 7 records in them (all the same) The third one that wasn't working appears now to be replicating but has only replicated 3 records. The three it has replicated are the same as in the other databases but in theory it should be 7 records as the others are I even ran them all at the same time but the same thing appears 2 of the databases have the same replicated data the the other on has only some of the replicated data." |
|
|
|
|
|
Replication