Hi, I have set up a merge replication on a sql server 2005 developer edition. i've notice after a period of tiome (aprox 10 days) that records are not replcated anymore. the replkication monitor shows that no records need to be merged. note that update is done mainly on the publisher Any hint...more >>

I've been trying to set up the publisher for transactional replication. The distribution server is sp2 the subscriber is sp3. I have set up replication on Server1 to be its own distributor. However I have been recieving errors such as this below: SQL Server Enterprise Manager could not ...more >>

We need to move a database to a new server that is the main replication server. The process was to build a new clean server and apply all patches and updates. Replicate with all servers, then backup the database. Restore this database to the new server. create a new subscription. All seemed to w...more >>

Well it only took a few days before the latency bounced back up again. I don't understand why this is happening. There is another server that has the same subscription that is operating over a WAN, and it doesn't have the same problems. Neither do any of the other subscriptions. Please help if...more >>

I am trying the snapshot replication. The publication and snapshot agency in a SQL Server 2000 machine and subscription in a SQL server 2005 machine. Is it possible? Thanks ...more >>

1. Can I initiate (create) a SQL Express merger subscription through web Https? Is that possible? Clients are mobile users and can not connect to the LAN to initiate the subscription. My problem is that I can't mange to connect the publisher using websync by programming, no matter what ...more >>

Hello I am using SQL SERVER 2005 and i am using merge replication in order to have my database replicates on handhelds.I have a virtual directory on IIS the handhelds are synchronising through GPRS . On the publication Acces list i use the server/IUSR_server default iis user and on the acc...more >>

Is there any command to check out any outstanding transactions not yet replicated to subscriber DB? Thanks in advance...more >>

Hi! Is there any table where I can find the last updated (last synced) date and time for a subscription? I am trying to warn a user if his/her subscription did not synchronise since an xxx number of days but I can't locate the date/time for the last successfull synchronisation. Thx, ...more >>

Hi all, I'm having a subscription on a bunch of laptops. When connected direct, no problem but when a user is out of the office, the job doesn't seem to start. It seems that the agent starts when the machine starts so I've set the merge-schedule to start every minute expecting it to fire ...more >>

Hi, I have the following situation and would like some advise. I am using SQL server 2005. I have smart clients access the database over the internet through web services. I currently have 1 data warehouse type database. It contains about 95% read only data which is apended to nightly. ...more >>

Hi, I'm currently configuring SQL Server mirroring on the same machine (named W2KPrincipal) by using the following scenario: SQL Default Instance = W2KPrincipal SQL Mirror Instance = W2KPrincipal\Mirror SQL Witness Instance = W2KPrincipal\Witness The trace flag has been configurered...more >>

I am trying to find a way to hide values from the legend in a graph. For instance, in the data fields section lets say I have three fields that I have entered (this is a stacked graph chart btw). If one of the fields sums up to 0 I would like to not display that. The chart is fine, obviou...more >>

Hello, Sorry for the stupid question but I am getting myself confused I guess. Not hard since it's Monday. If I want merge replication to manage my identities for autonumber columns on the subscriptions. Is the NOT FOR REPLICATION set to YES or NO? Thanks. Jake ...more >>

I set up merge replication but never change all the foreign key constraints to have the "Not for replication" attribute, we had this up and running for a couple of weeks prior to finding out that the foreign key constraint would fire during the replication process at times when it seemed to do t...more >>

If the logreader process stops, the server dies for example, and while it is not connected to the publisher transactions occur with the published database, will those transactions be lost, or will they be replicated by the logreader the next time it connects to the published database? Im thin...more >>

i have a merge replication set up between sql 2005 and express edition running on about 60 laptops. in addition to regular data users can also submit files, files get stored in varbin field. i am trying to figure out if it would be possible to have these files uploaded only, i.e server gets th...more >>

Hello, We're experiencing problems with the replication since a few days. I have a transactional replication process that have approximately 31 subscribers (Laptop) (User=MSDE, Server=SQL Server 2000 Enterprise). This process is running fine since 3-4 years. The problems started this wee...more >>

I am trying to set up transactional replication between two SQL Server 2000 machines and when the synchronization starts (I'm pushing from the publisher to the subscriber), I get the following error: Could not find server 'x.x.x.x' in sysservers. Execute sp_addlinkedserver to add the server...more >>

We are trying to setup Merge replication on a table that contains inventory data and trying to create the custom conflict resolver through stored procedures. I was wondering if anyone had any experience with this if they could share how they set up their conflict resolution for this. From ...more >>

Hi, In my distribution data base, the system tables creation date is showing Dec 2002, but i replicated the database on feb 2006, I want to know why the table creation date is in year 2002. Please clarify me. rgds, Soura...more >>

Hi, I have set up replication successfully. Data from Publisher can be replicated to Subscriber. I can check the data directly from Enterprise Manager. Before replication, the application calling the database work perfectly. HOWEVER, after replication the application cannot operate with ...more >>

Using distribution agent for transactional replication. Say if i have a single transaction that inserts 50000 rows. And my default profile for the distrib agent is set to 100 for commitbatchzise and 1000 for commitbatchthreshold. So how does replication flow these 50000 commands ? How man...more >>

Hi - Can't seem to resolve this despite lots of similar posts... I get the following message: "The process could not bulk copy out of table '[dbo].[syncobj_0x3237413641354436]'. And then "Function Sequence Error". I ran a log but it didn't provide anything particularly useful except for: "S...more >>

There are ten DB Servers in live network. Out of 10 DB servers, one of them has the database and the contents are replicated throughout. The size of the database is about 20 GB and it is to be updated on weekly basis. The time frame for replication is limited to 2 hours and all the data mus...more >>

A little of background: I have a SQL Server 2000 merge replication publisher/distributor, the replication is done via Internet, so the snapshot is downloaded by ftp. Everything works great if the subscriber has it's firewall disabled, but if it's enabled, the server is contacted and when star...more >>

Ok, here's a weird one. I've got a table that I'm (merge) replicating using the default method to handle conflicts. When I make a change to the publisher, the change will propogate to the subscriber, and vice-versa. However when I force a conflict by changing the same records on each server...more >>

Does Microsoft SQL 2000 Replication require that a primary key be defined on all tables to be replicated between databases? We are planning on using Replication to create a near real-time reporting database, based upon our production database records. Thanks -- Vilma J....more >>

Hi, I have a table called tblA in ServerA that i want to replicate to ServerB. Assuming i have done a full replication to ServerB but now However, among the 10 columns in TblA i only want to replicate only col 1 -4 i.e any changes made in TblA in these columns it will be reflected in TblA o...more >>

Hi, when i create a new publication (SQL 2005) i'm getting this error: The database context has been changed (translated from german) =================================== SQL Server could not create publication 'ASW2'. (New Publication Wizard) =================================== A...more >>

I have transactional replication working and it created a remote server to be used for replication. I am not able to insert/delete/update between the two servers through the "remote server" connection. I need to use a linked server, do I need to set up this linked server prior to configuring a...more >>

Transactional Replication, SQL Server 2005 Initialization fails and it says cannot read snapshot files. I ensured the files were corrected in the default location. In the second try, I put snapshot files in a different fold which was shared with everyone for read. But it returned the same err...more >>

HI All, Using SQL Server 2000 SP3. Replication is set up on a few databases, on each of the tables that are replicated the following trigger appears: create trigger [sp_MSsync_upd_trig_Voucher_1] on [dbo].[Voucher] for update as declare @rc int select @rc = @@ROWCOUNT if @rc...more >>

Can SQL Express subscribe to an SQL 2000 Enterprise publisher/distributor using Transactional replication? My investigations suggest yes, but only via RMO programming to synchronise only with a 'Pull' subscription. Correct me if I'm wrong, but I understand a 'push' subscription can only wor...more >>

Hi there. I am using backup/rrestore to prepare transactional replication. After restoring the backup on the subscriber, I tried to run sp_scriptpulication customerprocs at the pulbisher and got msg 14013 level 16 state 1 'This database is not enabled for publication.' I have created public...more >>

Is it safe to setup replication on an active production db? Using SQL 2000 SP3 on both ends, If so anything I should look out for? Thanks B.P....more >>

We are replicating 5 subscriptions to 500 users with MSDE databases. All databases are SQL Server 2000 SP4. The issue we are seeing is that some users are not seeing all the records they should. (Merge replication) Examples: User A creates some new records. The records get replicated to...more >>

Is it safe to setup Replication on a live "Active Sql 2000 SP3 database? Anything I should look out for?? Thanks BP...more >>

Hi we have to drop a replicated table and then recreate it. to drop a replicated table I used this MS article. http://support.microsoft.com/?id=326352 Iam able to drop this table and recrate it new table but I can not re add this table in the replication. Can any one tell how can I add back t...more >>

Hi, I'am working with a merge Replication and a pull Subscription on demand from the client I'am getting this message error from a vb.net Windows Application DATE=2006-03-15 15:18:34 ERROR=SyncJMI.CDatabaseUtils.LoadDataTable failed. System.Data.SqlClient.SqlException: General network e...more >>

Does the database compatibility level setting affect merge replication performance on 2005? Thanks. ...more >>

I'm kind of a newbie to MS SQL. I've been using it for a while but mostly from a programmer's perspective. I now have to manage a SQL server that is at a remote location. I want to replicate data from the remote production server to our office server. The data is to big to export (or bac...more >>

Is there an easy and quick way to temporarily pause replication on a specific publication/subscription and then start it back up again? Thanks, Mark ...more >>

Hi I'm busy configuring merge replication with Web Synchronization for portable users. The publication creates, i register the SSL certificate successfully and create the IIS virtual directory no problem with a user which has permissions to access the virtual directory. I install the certif...more >>

Hi folks, We're have rows from a static lookup table deleted frequently from our server during replication sync sessions. Our server is w2k, sql server 2000 with sp4 merge replication. When i look at the replication conficts using the conflict viewer i am seeing lots of conflicts on the table...more >>