hi all, my sql server has sp4 installed. i have two databases, D1 and D2. And the transaction replication copys table D1.T1 to D2.T1 at 1:00pm everyday. the problem is: when some applications are continuously using table D2.T1, i mean those processes are in runnable status. And then the r...more >>

I recently rolled out replication on our production server (MS SQL 2000 8.00.2039) and every time a subscriber tries to sync the following always appears in the Merge Agent History: "Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts)" This always takes over 5m...more >>

I recently setup merge replication and for each subscriber I add and try and synchronize I get the following error message: "The Process Could Not Log Conflict Information" When I view the details of the error it states the following: "The Process Could Not Log Conflict Information...more >>

I am experiencing this problem. Deadlock of these two M$ stored procedures : sp_MSget_repl_commands (Executed by the Distribution Agent --pull subscriber ) and sp_MSdistribution_cleanup (Executed by the Distribution Agent Cleanup job) the offending queries are : >From sp_MSdistribution...more >>

Hope you help me..... Two SBS 2000's (trying to get the damn think to replicate). BROAD has fixed IP of 81.174.xxx.xxx and CLIFT has 81.174.xxx.xxx Broad is set as the subscriber, Clift as the distributor Broad can ping, tracert Clift using IP and Name ISA firewall ports open to allow...more >>

Am I doing this right Create Publication with dynamic filters ie. select * from employee where employeelogin = SUSER_NAME() 1. Create Snap Shot 2. Create Dynamic Snap shot with SUSER_NAME() parmater filled in ie SUSERNAME() = mydomain\myuser 3. Pick a new folder for dynamic snap shot ...more >>

error i get from replication when i force them to run the process. mircosoft sql - DMO(ODBC sql state:42000) Error 14258: Cannot perform this operation while sqlserveragent is starting.try again. But i not restart any sqlserveragent And the sql server servies manager show that all running...more >>

Last week I made the following post.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Running Win 2003 & SQL 2005 on both machines. I created a publication on serverA. I subscribed to it on serverB. I received the error.... Command attempted: E:\Program Files\Microsoft SQL Server\M...more >>

Hi! I'm developing a project in which I have several Sql Server Express and Sql Server Mobile 2005 databases and all of them are subscribed to a central Sql Server 2005 database. Now, I'm in trouble with the primary keys because if i insert two registers with the same primary key in two dif...more >>

All, Transactional Pull model: Multiple publishers with the same articles(2000) : Single Subscriber (2005) I try to setup replication from the second publisher when the first publisher's distribution agent is actively pulling data. At this point, the storeprocedures indicating the insert an...more >>

Things I got to work SQL2K, Merge Publication -> SQL Everywhere (I used the interface in SQL2K5 to do this Subscribe, can anyone show me how to do it in C# 2005 code???) SQL2k Merge Publication with Dynamic filters(i.e SUSER_SNAME) -> To Another instance of SQL2k What I would like to kno...more >>

Hi, I want to write a vb.net program (vb.net 2005 & sql server 2000) to control the replication for sql server. How can I get the exist distribution control object to reinit the replication before I start the transactional replication? using the stored procedure or vb object? Thanks. ...more >>

Merge replication, SQL 2000. Does anyone know if there is a problem with syncronizing caused by the physical order of the inserts/updates in related tables? I am getting some conflicts that indicate a failure due to "... Referential integrity rules require a related record in the table '<t...more >>

We have an SQL 2000 merge replication set that consists of 2 publications. One is for tables only and the other is for SQL views and stored procs. I need to create a new table and revise some triggers in other tables. I also have to add a new SQL view that will be a merge object also. Can I...more >>

I'm reposting this because no one responded to my Dec 12 post. There has to be a way of dealing with upload insert failures. Could someone please point me in the right direction? --------- I have one article giving me problems in my topology which involves multiple Sql Server 2005 Express sub...more >>

Hello all, I have a snapshot publication with several anonymous pulls set up to replicate several procedures and functions. I notice that the created snapshot has a file called snapshot.pre that seems to drop all the functions. I'm not sure why this would be necessary because each .sch file s...more >>

Does anyone know if one way merge replication is used, can changes be made to the client data? Would these changes just be overwritten when syncronization is performed, or would the changes interfere with the replication somehow? Thanks. ...more >>

Hello. Has anybody used the TableDiff utility to compare a SQL Server 2000 publisher and a SQL Server 2000 subscriber? If so, did you encounter any issues with it? Thanks! ...more >>

I execute a sp_addscriptexec because I wanted to create a trigger, but it already exists in some of the subscribers. So, I get the following error: "....\Microsoft SQL Server\MSSQL$SQLSERVER2000\ReplData\20061213182034400\script_trigger.sql' could not be propagated to the subscriber." How c...more >>

Hi I'm trying Merge replication with pull subscriber and dynamic filter. I put -hostname like this: -hostname @@servername at step job of Merge agent at subscriber, so when start first snapshot, show this message: The schema script '\\D001ADP01\r$\sqldevices\MSSQL$BDP01\ReplData\unc\ D001AD...more >>

Hi, I've configured mirroring on the database and selected the high safety without automatic failover. It all seems fine. Now the problem is in the mirroring screen I can't select the High performance mode (Asynchronous ). I would like to test this option as well. I know I can't select ...more >>