Hi, I have a local and a remote sql server that connect to remote via dial-up connection. In local server, I'm member of sysadmin server role but in remote server just member of dbowner database role. I create my publication on the local but when I want to create pull subscription at the subs...more >>

I recently did a test-run of continuous merge pull replication on my intranet and it worked wonderfully. Now I am trying to make it work over the net, and I just can't get server names to ever work correctly! The server is listening on a non-standard port and this is open from the firewall.. a ...more >>

Hello, I have replication b/w 2 SQL 7.0 SP4 servers over a t1 connection. The type of replication is non-immediate updating transactional replication pushing 1 way. Sometimes the t1 connection will die. When the connection comes back up the SQL Servers begin replicating again. What happ...more >>

Hi There, i am using msde 2000 sp3 and sql 2000 sp3 as a subscriber and distributer or publisher. I created a merge replication programatically so when user click synchronize it synchronize between msde and server. When i try to run the program the following message come. " -2147221504- n[m...more >>

Hello. Is it possible (and/or wise/unwise) to have a SQL 2000 publisher and a remote SQL 7.0 Distributor? Thanks in advance, Mike ...more >>

Hi; Is there any way to solve the problem that when I import data from any database to another one my relations between the updated tables would not lost. Thanks ...more >>

hi all, i need to establish replication betwen postgresql and sqlserver2000 .is any one allready did this type of replication. is it possible to establish replication between sqlserver2000 database and any linkedserver.for example i linked the postgresqlsql server with sqlserver2000 through od...more >>

Hi, I have been using conflict viewer of my publication for a long time, but since I installed SP3 of sql server, this error appears when I want to start conflict viewer: An unexpected error occurred while trying to launch the Conflict Viewer. Any help would be greatly appreciated. Amin ...more >>

Client software for my application is run by individuals with DHCP connections. These individuals store data in MSDE. For all practical purposes, it seems that my central public internet server needs to be in continuous sync with the client (updates are done by both the client application and ...more >>

Dear all, I am a new comer in replication with Pocket PC. When I run with sample NorthwindCe application and replication with my SQL server. The following error have been occur: Error Code :80072F76 Message : Header information is either corrupted or missing. [,,,Header name,,] Minor Err.:...more >>

I;m trying to replicate two database on two differn't SQL2000 servers. I get a error on one datebase, to many rows can only handle 259 or something like that if I can remember is there a link to a web site I can go to. Thanks J ...more >>

urgently need help. i have 1 publisher (say s0). then i do pull subscribe from s1 (continously running). when i update s0 data with dts, the replication goes right. now i make another subscriber s2 (continuously running). and when i update s0, many confilcts like below occurs: The row was u...more >>

hi all, is there any code or function or procedure to change the identity property of all columns in a database from yes to NO identityproperty yes to NO thanks&regards reddy...more >>

One of my merge replication table has a timestamp column (to know last n products sold in order). 99% percent of the rows are getting updated to the server without any conflict, but some rows are giving conflict, and in the conflict viewer when i am applying the changes made at the clien...more >>

I have used the script file to make a transcation repliation. All the things goes well except a bug, when the script executed over, the snapshot does not start copy at once and need me go to the enterprise manager and right click it in the replication monitor to start it, I just want to start it...more >>

I have a hosted SQL database. The hosting company does not offer to setup merge replication for me. 1) Is there a hosting company that offers replication too ? 2) If I can't do replication, is there anyway to merge two databases using a DTS package or something ? Thanks. -- Michael T...more >>

Hello. We are currently replicating data over for serveral companies on a win2k server with sql2000. We just bought a new 2003 server with sql2000. Being two different 0S's and service packs and two different server names. What is the best way to move replication from the 2k server...more >>

Hi, I have 1 subscriber who has not synched up to the publisher for the past 11 days and the publisher is set to expire a subscriber if they havent synched up in the last 14 days (default). We are having a power problem at the subscriber site, so they cant synch up. If I change the expiry ...more >>

I have a table that is being replicated.. i would like to increase the size of this column.. Is there a way to do this without dropping the subscription? Thanks, niv...more >>

Hi - First, I'm not a network administrator. More importantly, my users certainly will not be network administrators. I'm using VB.NET to build an application that will have components on the desktop or network and on a Pocket PC. This is not an Internet application. The desktop applic...more >>

What it makes to generate this error: The row was not found at the Subscriber when applying the replicated command. The stranger is that the detected register does not exist. ...more >>

hi all, i did mergereplication successfully between two servers with no synch option.now my problem is... i am doing hospital management project .in that appointments done online from patients.suppose publisher is in one place and subscriber is in another place.now in publisher we will generate t...more >>

hi all, i did the transactional replication successfully.after that for security reasons i changed the sa password of the publisher server and subscriber server.now replication is not working.it is giving message unable to connect the subscriber,log in failed for user sa. i tried in all ways.but n...more >>

Hello, I have a SQL server in a primary location that is not attached to a SAN it is serving SQL locally. I want this data to be replicated to our Secondary DR site. These 2 enviornments can not communicate unless there was a Disater. How can I get the SQl data on to the DR site. I what can I...more >>

Finally got my anonymous replication working. Now, the changes I make @ the subscriber replicate to my publisher, but the changes I make @ the publisher do not replicate to my subscriber. I see a record that the update was supposed to happen, but nothing comes over to the subscriber. I don't...more >>

Hi, I am using the default datetime(Later wins) conflict resolver for merge replication (sql server 2000). I have a trigger on a 'datetime' variablethat updates the time whenever an insert or an update is done. When this update is done on either side, the replication happens without a problem. ...more >>

upon deleting a subscription to a merge publication you get this choice: "the subscription has been succesfully deleted at the publisher and distributor. however, the subscription information and previously replicated data has not been deleted at the subscriber. do you want sql server enterp...more >>

My replication agents occassionally would stop replicating. Is there a way that I can set something up that would automatically restart the agents. Any help would be great. tx ...more >>

If transaction replication create a timestamp column on the new table, It would has a problem when user do update and delete records. How do people use it as a standby server when there is an extra field in the table? I am new to Replication, and any help would be greatly appreciated, culam...more >>

Hi, I created a few push subscriptions in continuous mode for testing merge replication. I stopped the synchronization before I tried to delete the publication. I got an error stating, can't delete because the publication is being used for replication. I can't delete the subscriptions on the su...more >>

Just a general question ..... When the initial snapshot for a replication runs, I see it creates a bunch of sp_MSins, sp_MSdel, and sp_MSupd, 3 stored procedures for each of the articles in my publication. I see these sp's at the subscriber db, but what I do not understand is why I see 2 stor...more >>

Hi Guys, in sql server log shipping for fail overing to stand by server if i need to restore transaction log recovered from primary server. how i can do that?is it using script or Enterprise manager? what is the script used? pls advice me. Thanks Biju...more >>

Hi there, I have a SQL Server behind a 3COM Superstack firewall. We want to be able to connect with one of our clients using SQL replication over VPN. Does someone have the steps neccessary fo this, or are there any hidden items to be aware of? Thanks, Jane...more >>

Does more than one msrepl_commands record exist for each record updated? How can I have so many rows in this table? Does anyone know how to translate the command fields so I can see what the commands are... with so many records sp_browsereplcmds isn't even responding. Thanks ...more >>

I'm doing a transactional replication for the first time between 2 servers. After 14 minutes of running (according to the logs), the replicaton crashes. This is what I find in the log file generated by the distribution agent. It starts bulk copying data from many tables until it finally crashes...more >>

Hi, So, I have setup transactional replication, uses the initial snapshot. When the snapshot is being posted, it runs the same command, and causing it to fail on the primary key constraint. Has anyone seen this before? ...more >>

I am new to merge replication... I am planning and testing for changing a current snapshot replication scheme to a merge scheme. Are table design changes replicated? adding fields for example? and if so in which directions? In other words if design changes are replicated will a change at the sub...more >>

Strange thing has happened on one of our servers. The publications have disappeared from under the replication monitor/publishers in Enterprise Manager. We can still see them under replication/publications though. Any ideas what may cause this? Thanks Ray ...more >>

We have 2.8 million records going via replication from server A to server B. Our server seemed to be grinding to a halt and when I examined sp_lock, it seems the replication process from server A had 2.1 million locks on the database. Does this mean that the destination server puts some kind o...more >>

Hi, I have set a transactional replication, and everything looks fine, but I get the following error message in my Subscriptions: ( 'Server Name' is not configured as a distributor. The step failed. ) any idea, Thanks...more >>

The error I'm getting is: Error 195: 'fn_escapemdshellsymbolremovequotes' is not a recognized fuction name. I can't find this error anywhere in the KB. Any Ideas...more >>

Is this possible? The tran log load process fails when someone is using the seconday database. The seconday is in read-only mode and the "with standby" option was chosen when setting up log shipping......more >>

How Can I Delete Push subscription at subscriber manually ? The Publication are droped ! Thanks --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching....more >>

Hi, While trying Merge replication for various publications, many conflict tables were created in the publisher database. Even after deleting the publications, they haven't gone off and neither can I delete them. Could someone suggest, how to delete the conflict tables? Thanks! PS....more >>

Hi, I was trying a pull subscription and I got all kinds of error messages all suggesting that the merge agent isn't being run or it isn't accessible. But, the moment I did a push subscription, it ran and replication happened without an error message. I don't understand why. My subscriber is an...more >>

Hi, I want to keep data sync between two databases. I am planning to use Transactional Replication to achieve this. I am using Replication and posting the messages into MSMQ .. Later the MSMQ is read using BIzTalk 2004 and do the necessary inserts/Updates/Deletes to the Target database. I would ...more >>

I have a FOR UPDATE trigger on a subscriber table. The trigger is not firing when data is replicated to it. If I change the trigger to FOR INSERT, UPDATE it works!! I don't want it for INSERT. Can anyone explain this behavior, and is there any way to get it to run with only FOR UPDATE? I ...more >>

Does the Replication Conflict Viewer install by default? and if so, does it only handle merge replication? are there any issues with using it on a clustered environment? Regards, Gary ...more >>

Im looking for some advice with regard to filtering data via Replication, and controlling referential integrity using triggers. Im struggling to find the best solution to achieve the most effective solution. Were using bidrectional merge replication. We have a relationships between tables i...more >>

I am wondering specifically when the changes on the Publisher are cleaned up. I have implemented merge replication with each publication having a retention time (set in sp_addmergepublication) of 18 months and a @max_disretention (set in sp_adddistributiondb) also at 18 months. Also I have a s...more >>

on the properties page for an agent (I referring mainly to snapshot and merge agents), on the general tab there is an 'enable' check box. Then on the schedule tab there is also an 'enable' checkbox for the shedule. If the enable checkbox on the general tab is not checked (disabled) but the ena...more >>

I am a bit confused on the snapshot agent role after the initial snapshot is taken. 1) merge replication is setup... initial snapshot was taken and used to initialise subscribers. Now my question, if the snapshot agent is on a schedule and set to run agian, will the subscribers be re-initializ...more >>

When you create a new publication in sql server 2000 there is a REPL- snapshot job that is created and runs on Sat.(by deafult) What exactly is this job for? It appears that it runs the snapshot agent (among other things). If the snapshot agent is running in this job on Sat. what happe...more >>

We are planning on changing IP addresses on two database servers that have SQL transactional replication between them. Before I get into any trouble, do you see any problem that could occur regarding the replication communication between the servers. My plan is to change the IP addresses...more >>

I have a merge replication process (on test data) that is moving a subset of data from one region to a central office. Now the central office has it's own existing data, prior to initializing the merge replication from this publisher. Basically, when a row that existed prior to initialization ...more >>

I have push merge replication with static filter setup. And, I can modify data on publisher, then push down to subsriber without any problem. But, if I have added new records, then those new inserted records can not be replicated to subscriber. The way to overcome this problem is to re-bulit snaps...more >>

Hi, I am running SQL2000 SP3. On the publisher I created a publication with an article called Organization. In this table there is a field ID_OWNER which is the filtering field. For example ID_OWNER = 34. There a also join filters based on Organization. When I first setup the merge replication...more >>

Hi, I am part of the replmonitor role of a distribution database. I am able to view the agents of the distribution database but i am unable to start or stop any agent. the books online says that i should be able to. Reference Replication/administering and monitoring replication/Tools for ...more >>