I have configured a merge publication using dynamic filters with SQL Server 2005. I can successfully initialize new subscriptions over the LAN. However, I cannot initialize new subscriptions using web synchronization. I receive the error, "The merge process could not allocate memory for a...more >>

Hi, Just hoping to get any info on Replicating a progress DB to sql server 2005. I connect to progress DB via linked server in sql through ODBC. I there a doc out there that explains this?. I found 'Programming Snapshot or Transactional Replication from Heterogeneous Data Sources' but thi...more >>

Hello - I am trying to set up a server to server (both are SQL 2005) Transactional Replication publication. (Source = Server A, Target = Server B) In this situation, Server B (the source) only needs to receive the data, first the initial snapshot and then any subsequent Updates. Server B...more >>

Hi repl distribution job is running fine but job is not updating.when i click refreshjob not showing any thing if i stop it then it will show cancelled in history but when i run it it will run but shows nothing in history. please give some ideas Thanks -- Message posted via SQ...more >>

Hi I am sqlserver dba.recently in our company we have a big issue in replication the data is not moving from source to destination finally i made it move with the help of sql monster articles now everyone is happy but when i double click distributor agent which is under Replication monito...more >>

Hi, guys we met a power failure this afternoon which last 1 hour. We couldn't run the snapshot agent (merge replication) after the power went back. The error message is: 'The process could not bulk copy of table XXX Error number: 3624 There is no more detail error message was...more >>

I'm running SQL 2000 SP4 and want to set up Log Shipping between a primary and standby server. When I run the Maint Plan wizard, I select the specific database but there's no option to do Log Shipping on the screen. I'm running v8.0 of the Enterprise manager. Is there a version issue?...more >>

Hi I have major problems reconfiguring my MSSQL 20005 server regarding replication. We had to reinstall Windows and MSSQL2005 because of some diskproblems. After reinstalling we attached our database back which were copied to another server before. Some database had merge replication set u...more >>

We have been unable to create a new snapshot since the first one that was created when we initialized the publication. Below is the log entry of the offending step. Any ideas on the cause or how to find the cause? Thanks, 2006-05-12 05:28:15.76 [0%] Preparing table '[dbo].[TestsAsmReading...more >>

I need help to add fields on couple of publisher database(articles). i want to know best of adding fields & how to apply schema update on Subscriber side. i know little bit about sp_repladdcolumn. but details steps will be highly appreciated....more >>

Sorry for the battery of questions. Are there any risks or complications from changing an article with compensate_for_errors = false? Does it force any reinitialization of subs? Does it grow the msmerge_contents/tomb tables much? I am guessing this will add some conflicts to manage...more >>

Hi, Tell me please, is there any chance to lose or get altered data in a susbcription database if the character mode format of snapshots and transformable subscriptions are used in the transactional replication that was set up between MS SQL Server 2000 SP3 servers? --Many thanks, Oskar ...more >>

I am planning to replicate tables from a remote server RemoteServer to my local server 'LocalServer' using transactional replication; also I need to control everything from my local server. I need some assistance / clarifications for the following 1. I am thinking pull method. Am I right? 2....more >>

Hi! Is there any way to find out which articles take time in merge replication with dynamic filters. We added a number of tables to our replicable database. The relation between the added tabels and existing ones is through id filelds (primary key). Relations between the data form tree-like...more >>

Hi Am I correct in assuming that in transactional replication the Insert stored procedure are not executed when it is doing a bulk copy (after reinitializing the subscription) In MS SQL 2000? -Dick Christoph ...more >>

Would you consider it a bug in transactional replication that UPDATETEXT statements are replicated to the subscribers regardless of any row filters on the article with the text column being updated in the publication? It just took me a couple days to track down why my transactional replic...more >>

We are planning to set up a remote location over VPN besides our corporate offices. Both locations will modify entries more or less equally frequent, although we could specify certain tables that are more frequently edited on on end versus the other. Connectivity should be good but not excelle...more >>

Hello, I am just starting out in the replicatin scene. I am reading a manual on the topic but still in the early chapters. What I did for practice was to create a publisher/distributor on my dev server using the wizard, but it is not working. I did get a message that the location of the ...more >>

Hi I am trying to determine why in transactional replication sometimes it creates two stored procedures for inserts/updates/deletes and sometimes only one. For example below I have replicated a table called dd_container_property and it creates one delete stored procedure and for the table c...more >>

hi all, I was trying to set the articles to "delete data in the existing table that matches the row filter" in the publications "article>articles>table articles>snapshot" of the publication but everytime i reopen that property tab the publication restore to default setting to "drop ...more >>

Hello, I had to add some varchar columns to a table that is being used for replication. I was able to add and save the columns, and that did not disrupt the replication. I performed this operation through Enterprise Manager rather than Tsql. However, the columns are allowing nulls by d...more >>

In SQL Server 2000, an identity column would be replicated to its base type (in my case an int) on the subscriber when you were doing transactional replication with immediate subscribers. This worked great, it allowed the identity column to not have any gaps with inserts to the publisher and ...more >>

I have two servers SQL 2000 in different locations and they used to do merge replication using internet leased lines. Both these two servers also used to have public IP addresses. Now my problem is my subscriber server is now located to another location and it does have a dial-up line only, n...more >>

Hi; Is posible transactional replication trough HTTP (distributor and suscribers) protocol in Sql Server 2000 I need implementation replication schema in a secure network trough Internet that only permit HTTP trafic Thanks in advanced ...more >>

Hello All, I am trying to come up with the best replication model in my collocation environment. Would like to hear some comments. So here is the scenario: 1. In our server room we have MS SQL Server 2005 Enterprise installed on server DATA1 (dedicated data server). 2. We also have MS SQL...more >>

Hello, We are trying to set up SQL Server 2005 Transactional Replication, but we are having trouble pushing the subscription once the publication is complete. We execute the following command: - exec sp_addsubscription @publication = N'AAMS02PAS_ALL_PFS', @subscriber = N'PASDSERV\Test...more >>

Folks, We're running merge replication between two SQL Server 2000 SP4 instances. The installation is pretty vanilla and the load being replicated is very light. Replicatiion seems to be working normally, but for the following exception: one column in of our articles will not replicate p...more >>

Can someone please tell me what good books or websites I can go to for learning Merge Replication? Hilary - Your book on Transactional/Snapshot Replication is awesome. Do you have anything coming up on Merge Replication any time soon? Thanks. Adam....more >>

Hi , I got the following error message on the snapshot of my replication Transaction (Process ID 72) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (Source: scalaDB_IPT_SubL_PubTrans (Data source); Error number: 1205)...more >>

I'm trying to setup transaction replication between 2 servers. This is a one-way replication: Server A to Server B, not Server B to Server A. I am able to replicate all the tables except one. I added commands to the agent so that it would create an output file, possibly with more or better ...more >>

Hi.... I have sql server 2005 evaluation edition. And This version doesn't provides Mirroring option.Even after installation of service Pack1. Is there any other edition (Freeware or Evaluation) which provides the Database Mirroring ? waiting for the prompt reply. Thanks ...more >>

Hi guys Setup: I have 2 SQL Server 2000 SP4. I have set up Transactional Updateable Replication between these two servers. The Publisher runs Windows 2000 Server and the Publisher Windows 2003 Server. I have allowed MS DTC Out bound on the Subscriber. Problem: I can update from Publish...more >>

I am running this script insert into server20.po_system.dbo.po_detail select * from po_system.dbo.po_detail where createlocation = 999 and shiptolocation = 20 I receive the error Violation of PRIMARY KEY constraint 'PK_PO_Detail'. Cannot insert duplicate key in object 'PO_Detail'. The...more >>

Hello! I work in a Transactional Replication with queue udpate. I Create an article and add it to a publication with sp_addarticle. exec sp_addarticle @publication =3D N'Publisher', @article =3D N'Table', @source_owner =3D N'dbo', @source_...more >>

Hi there, For a POS solution I am reading about replication. Some simple tests with SQL 2000 and MSDE are looking good. The only problem is that the database used can be larger than 4GB. If SQL 2005 Express acts as a subscriber, is the 4GB limit still active? Hope to hear from you, Pat ...more >>

setup: sql2k5 SP1 queued updating subscription distributor same machine as publisher scenarion: publisher is down subscriber is running question(s): what happens to transactions in the subscriber while the publisher is down (hence queue reader and distribution agents are a...more >>

setup: sql2k5 SP1 queued updating subscription distributor same machine as publisher scenarion: publisher is down subscriber is running question(s): what happens to transactions in the subscriber while the publisher is down (hence log reader and distribution agents are also not ru...more >>

Hi All, Since I have the full set of data in Subscriber, I selected "The subscriber already has the schema and data" when setting the transaction replication. However, I find that only the data change in the Publisher will be replicated to Subscriber. Add articles, add column action will no...more >>

When Replication monitor shows an error icon, I removed all the replication jobs completedly. After I reconfigured publishing, subscriber,Distribution, why the replication monitor still shows an error icon even though there is no replication job scheduled? Thank you! ...more >>

Hi We set up a transactional replication with a publisher and two subscribers with Queue update option. This setup was working fine for about one year but now the Queue Agent was failing with error "Unexpected Synctran Procedure Type s provided by Queued triggers." "Failed while applying...more >>

I try to program snapshot replication between SQL 2000 and 2005 with vb. I test the the ActiveX8.0 with vb6 and the program can create snapshot files and push or pull data from SQL 2000 server to SQL2000 server. I also test the RMO and ActiveX9.0 with VBNET 2005, the program can create snaps...more >>

Hi , This is with regards to an earlier posting : (1) sp_browsereplcmds will show you the command in human-readable format (2) The above command will indicate which table on the subscriber is affected. (3) The agent history will report any errors. You can also enable logging to a tex...more >>

Hello everyone, We have a spot of a problem with the Windows Synchronisation Manager. Basically, this is the situation. We have a number of field agents who travel around the country and who have to replicate information with out headquarters a few times a day (we use merge replication - S...more >>

Hi all, I'm trying to investigate some options, as I know I will have to tackle these issues soon. The first issue: We have two office locations, about 15 minutes drive apart. We currently have Sql Server 2005 Standard in our main office, but will be expanding an application to the other ...more >>

Hi: I restored a backup of the publisher database from production to dev server. After restoring on dev when I truncate the log I get the follwoing message "The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is runni...more >>

Hello; We are unable to replicate text data type columns in our current implementation of replication. It always fails. We have cut these columns out of our replication, but would really like to have them. Is there a way to get text data type columns replicated? -- Thanks. DC Stewart...more >>