Replication

MS Access Sync/Replication With SQL Server
We have about 70 locations that run MS Access (2K) and want to synchronize with a central MS SQL Server database. Can this be done and if so can someone please point me to where I might find more information? Thank you. IC ... 9 Aug 2008 01:21

Conflict Replication
Hi, We have a merge replication between our 3 SQL servers at 3 different locations. 1 is the Publisher and 2 are subscribers. We have PK on a table. (unique field which is auto incremental by 1) On the Publisher if the user creates a new order, the table assigns it a number e.g. 1000 in the unique field (auto-... 8 Aug 2008 12:00

What agent executes sp_adjustpublisheridentityrange?
I am a SQL novice and this is my 1st time using replication. I'm using merge replication to publish on sever 2005 and pull subscribers using express 2005. All seemed great, until I could not longer add items to a particular table on the publisher. It gave an error stating I needed to run sp_adjustpublisherident... 7 Aug 2008 21:42

READ_COMMITTED_SNAPSHOT setting / replication errors?
We have 2 databases ( publisher / subscriber ) participating in a transactional replication arrangement ( 1-way ). It's been (probably) months since we have had to fix a problem by reinitializing a subscription between the two. Last night, ( in an effort to reduce deadlocks ) we applied the READ_COMMITTED_SNAP... 7 Aug 2008 21:42

The initial snapshot for publication '' is not yet available
SQL 2005 - SP1 We had a server reboot last night and now my replication-monitor with message 'The initial snapshot for publication '' is not yet available on Distributor-Subscriber tab and is NOT replicating to subscriber. Upon debugging I found, my snapshot folder is deleted by some process. I am not sure if... 7 Aug 2008 08:19

replication agent has not logged a progress message in 10 minutes
SQL 2005 on windows 2003 Staring on Friday, the purblisher started receiving this error to one subscriber (the other subscriber is fine). "replication agent has not logged a progress message in 10 minutes" I have changed the agent profile to Slow Link Agent, but that has made no difference. THe replication... 11 Aug 2008 17:42

Delete actions Replication
Is there anyway to stop delete transaction from being replicated to the replicated server. Using SQl Server 2005 transactional replication -- Message posted via http://www.sqlmonster.com ... 5 Aug 2008 16:19

Is partitioned replication correct???
Configruation: Main SQL Server - SQL 2005 Remote SQL Servers SQL 2000 & 2005 I am looking to setup a partitioned transactional publication from my main SQL Server to all my locations. The remote server names/SQL Instances all have the location number in their name Location05Server or R33S-Server. So what w... 7 Aug 2008 05:15

replication agent has not logged a progress message in 10 minutes
SQL 2005 on windows 2003 Staring on Friday, the purblisher started receiving this error to one subscriber (the other subscriber is fine). I have changed the agent profile to Slow Link Agent, but that has made no difference. THe replication monitor stays on "connecting to subscriber subscriber1" and doesn't cha... 4 Aug 2008 01:19

Replicated commands sometimes not executed on the subscriber side
are you using the continue on data consistency error profile? "Andy Cholerton" wrote in message news:2008731113413andrew.cholerton(a)eds.com... We have the same issue on our environment now we have upgraded to SQL Server 2005. We also have one database replicating to 2 others via 2 separate publications, ... 2 Aug 2008 08:26