Hey, Is there a way I can start or stop my transactional replication synchronization using sql stored procedures or sql scripts? any help would be great. Thanks Jatin ...more >>

We have some tables set up doing merge replication, and just came across http://support.microsoft.com/default.aspx?scid=kb;en-us;828637&Product=sql2k Is this gist of this, that when a compensating change condition exists, that potentially good rows that cannot be replicated out, are instead DE...more >>

Currently, we have a table replicated from one database to another on the same server. If I update 127 records based on the primary key, the subscription process locks all the records until all the 127 commands have been executed. Seamingly regardless of how they were updated. eg. CREATE...more >>

Hi, I have a problem at the moment with replication. Publisher & distributer - SQL2000 Server Subscriber - SQL2000 Server Transational Replication Here is a simplified schema. CREATE TABLE ClientData ( CID CHAR(17) primary key , Code1 VARCHAR(6) NOT NULL , otherFields varchar(10) Nu...more >>

Normally when snapshot is applied only publisher data is downloaded to subscriber. Is there a way to have subscriber upload its table data when synchronization is done for the first time i.e. when snapshot is applied. Thanks!!! ...more >>

Any nice VB.NET RMO samples out there? I'd like to replace the functionality of windows syncronization manager samples beyond the BOL... Thanks!! ...more >>

Does anyone know if SQL 2000 Replication uses NetBios or Instance Name when setting up a new replication partner? The reason I'm asking is because we've got a server with a hostname of 16 characters long. The instance name is the same as the hostname, which is also 16 characters long. When try...more >>

Hi , I found that i could only set up a db in the server as either a snapshot/merger replication with the transactional replication greyed out any reason why i am not able to make it a transactional replication ? tks & rdgs -- Message posted via SQLMonster.com http://www.sqlmonste...more >>

Hi , At first i was trying to set up replication where i got the Error 18483: could not connect to server 'SQL1; because 'distributor_admin' is not defined as a remote login at the server. as per some of the posting i used "Select @@Servername" (e.g SQL2)and found that the name returne...more >>

I have Merge Replication setup between the server and a handfull of tablets. All of the tables are setup identically; however, one table has stopped merging. When an update is made on the disconnected subscriber, and replication occurs the data is replicated to the server but removed from the ta...more >>

Hi everybody... I'm testing a system with one distribution server and 2 subscribers (pointing to 2 different publications on server)(planning to add other 7 subscribers on it!). I'm using bidirectional transactional replication. Sql server 2000 is installed everywhere. All the system works ...more >>

I want to eliminate a table but this it marks the message to me: Server: Msg 3724, Level 16, State 2, Line 1 Cannot drop the table 'NOM_TABLE' because it is being used for = replication.=20 This pertenecia to one, but no longer exists the replication, now which = I want to eliminate it leav...more >>

Was web synchronization for merge replication available in SQL Server 2000? Thanks, RSH ...more >>

Hi: I have a publication with larger sql table articles. I want to add another article (small table). To start replicating, I will need to reinitialize and rerun the snaphot. I don't want to run the snapshot during the day time because it may block other users because publication has som...more >>

What is the syntax for a no sync initialization when using scripts to = create publication & subscription & subscription agent? --=20 JLS...more >>

Good day I have a simple transactional replication set up between two SQL2000 servers. A single table is replicated with columns of type int, bit and varchar. The server with the subscription has had SP3 for quite some time, however after we installed SP3 on the publishing server, we start...more >>

Hi, I have both my server at different location with around 4GB of database and network is poor. I am trying this feature of SQl 2005 replication which allows initial snapshot from backup. I could do it with pubs db but couldn't understand some points. Expert's advice will be greatly app...more >>

I've set up two servers for HA, primary and secondary. The transactional replication works find between these 2 servers. After testing the failover, we want to bring the database back to primary server and continue the replication. Can someone provide me the procedure of doing the failback?...more >>

I'm implementing merge replicatoin between 2 SQL Server instances. This is working fine, except for 1 issue. The publisher database tables are owned by the TestPartner user and when I run the merge agent the 1st time to create the objects in the subscriber DB, it creates the objects as the DBO...more >>

We are researching whether we can accomplish the following goal with log shipping. We have a reporting database that is mostly read-only that we would like to migrate to log shipping. Our environment consists of two database servers, one is our operational database server and the other is a r...more >>

i am working on a PDA application that uses RDA to push and pull data from SQL SERVER 2000. I managed to synchronize with GPRS connection . But when i disable GPRS and activate wireless connection, synchronization fails. Message is something like that: "request to send data to the computer ...more >>

hi : i got error when i run above command Cannot drop article 'Call' from publication 'RWBreathe_Publication' because its snapshot has been run and this publication could have active subscriptions. i used merge replication , and PDA as subscriber. Cheers Nick ...more >>

hi : i set up a merge replication on sql server 2000. how to modified replicated tables without dropping replication ? Cheers Nick ...more >>

Hi I have a table in a snapshot replication. This table has 42,000 rows before data is inserted its all deleted. My problem is that soon as the query trys to delete the data in the table the processor shoots up to 100% and the command just hangs and does not delete the data. Now this used to...more >>

I Have setup a pair of server with log shipping, it works perfectly, logs are backed up every 2 mins and restored succesfully to the destination server. My only problem is that the monitor (running on the backup server) thinks that things are not working correctly. It shows the correct times f...more >>

I had merge replication setup between 2 servers. I then stopped and removed replication, made some system changes, then setup replication again. But, it turns out all of the data from the publisher hadn't made it to the subscriber before I removed replication. Is there a command I can use ...more >>

I am very new at SQL replication. I set up a publication and distributor at our SQL 2000 server. All went fine. Now I am trying to create a laptop subscriber to use (I think) an anonymous subscription. I setup the laptop with MSDE 2000 SP3. I now want to create a subscription while connec...more >>

I have setup everything from my domain to the dmz following the document = from Replication Answers.com "Replication Across Non-Trusted Domains or = Using the Internet" When setting up the anonymous pull subscription, browsing for the DMZ = publication, I see the DMZ server (Publisher) but whe...more >>

Hi, I have transactional replication between 2 sql server 2000 sp3 servers. Log reader agent on one of them cannot deliver transactions to the distribution database. It's status is "delivering trasactions" all the time, but nothing is being delivered at all (all 0s). sp_who2 shows that it is...more >>

I have a strange situation.... All of a sudden, my publications are now <Multiple Publications> instead of each being listed individually. How can I 'split' these back up, to display each publication? -AND- How can I see what publications are contained in the <Multiple Publication> distrib...more >>

Hello folks, We're running out of space on the disk/partitions that hold our production database. The database is published using merge replication - win2000 server, sql service pack 4 The data disk is on a external disk array using raid 5 etc. We've bought in an additional array controll...more >>

I am getting the error below trying the 1st merge synch to my laptop. The laptop has MSDE2000 SP3 on it. I tried this synch right after I setup the database as a publisher. This is the 1st subscriber I have tried to create. Can anyone help? Thanks. David The schema script '\\LIFEDEV0...more >>

Some data was erroneouely changed in a table earlier this month. The table used to track documents that have been released for consumption. The field I wasnt to change is called modified_date and of course contains dates. Whenever I change the field manually and move to the next record, the valu...more >>

Hi I am getting a wierd message when I click on the SnapShot Agent. Error 14262, The Specified @job_id (###) does not exist any idea what could have caused this and what I can do to resolve this thanks P...more >>

Hi, I have a two servers .. and transactional replication .. working fine.... I have a new req where in I want to have a functionality of trigger on destination table. but I found that trigger on destination table works only whn you make modification via applcation or QA. modifications made vi...more >>

Hello there I have subscription who work perfectly In order to see all the chages at the time it being done I set it to work as soon as the publicion is done. But this way cost in working of comouter. the computers are working mutch more sloly. So i set it to work at 00:00 every day....more >>

This isn't so much a problem with the replication, I finally got that working. I am having problems with updating the source data on my notebook. Brief topology: SQL 2005 on notebook with publisher and distributor. A publication with 4 articles (all tableS) is subscribed to by my PDA running ...more >>

Hi there! I'm in the process of deploying a solution for mobile laptop users running SQL Express using merge replication to synchronise data with a central SQL 2005 server. My question relates to propagating schema changes achieved using the ALTER syntax. I have a table called client and...more >>

i am working on merge replication over internet i configure each and everything as Paul told in artical i configure TCP\IP port at client network utility as 1433, also server at server network utility as 1433 also FTP port at publisher properties is 21 but it is not working it show error as...more >>