SQL2K SP4 on both Publisher and Subscriber. Remote Distributor (on the Subscriber). NOT immediate-updating. Transactional. Continuous. I've had replication set up for a long time now (over a year) and this message is suddenly showing up on several of the Log Reader Agents. Whats really st...more >>

I want to clarify something regarding the deletes. On Publisher, we have a table which has foreign keys. I checked the same table in subscriber. It does not have foreign keys but it has primary and unique keys. Does Replication ensure that delete happen in the same order on all subscribers...more >>

I have primary key duplication issues on brand new snapshot of data, where subscriber is just a read-only reporting server. I am trying to turn on verbose history agent profile, but don't know specifics of doing this. Do I do it on the distribution agent or at the subscriber? Also, where does it ...more >>

We have about 52 clients on SQL Server 2005 using anonymous pull subscriptions (2 subs each). One of these clients had an issue with disk space so we had to recreate the subscriptions for the 2 databases. One subscription went fine but the second is getting the following error: The spec...more >>

I would like to setup transactional replication so that when the publisher finishes sending data out, a .NET 2.0 app is run. Is there an event I can grab onto, or would I have to set a trigger up on a system table?...more >>

Hi, have a SQL Server 2005 Standard edition with a publication of kind "Transactional with updatable subscribers". I would like to have SQL Server 2005 Workgroup Edition as a subscriber. Is it possible? Thanks. ...more >>

Hi, currently we have a table in sql server 2000 which has one column as length is 10 and which is part of transactional replication .That table as publication. Now i would like to change the length at publication side from that column i mention above to 100 , but it seem cannot do anything...more >>

We are having an issue whereby the log file on a database will not truncate once a snapshot publication is created for the database. -The database is set to the Simple Recovery Model. -Data in the database is updated/refreshed every 3 hours via a series of stored procedures which complete in...more >>

I keep getting the error message: An error occurred during decryption. There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'. Changed database context to 'master'. (Microsoft SQL Server, Error: 15466) I have tried a local ser...more >>

Hello, I am running multiple replication publication on a SQL 2k database, with a separate server as distribution agent, then finally push subscriptions to multiple databases across 5 servers. All publications use row and column filtering in them. My question is, can I use locking hin...more >>

Hi, Is it possible to have "Updatable subscription to Snapshot Publication" or this feature has been discontinued in SQL Server 2005? Thanks in advance, Leila ...more >>

Hi All, I am having some memory issues and SSL issues with my SQL 2000 box. I had SQL 2005 installed on this box, I uninstalled it when I had a crash of my production server. I installed SQL 2000 on this box and moved everything over. Everything including my replication was working fine th...more >>

Publisher w/ 2 subscribers, all running SQL 2000 SP4. Error in conflict viewer is: The row was inserted at 'APOLLO.MARFAS' but could not be inserted at 'ARTEMIS.MARFAS'. Unable to synchronize the row because due to an unspecified error. The reason is on artemis (a subscriber) they had run...more >>

I have seen a few threads asking about copying a complete server, including all of replication (merge), to a new server. I notice that the answers state that it should be possible as long as the server name remains the same. We are in this situation today, and do not have the luxury of recreat...more >>

I looked through this newsgroup for Error 3705, which states that I cannot use DROP VIEW on a particular view because it "thinks" it's a table so i am supposed to use DROP TABLE instead. The suggestions I found do not apply in this matter, so here goes... I have a snapshot replication publ...more >>

Hi, currently, we have some tables which are part of transactional replication now we want to build indexes on those tables but my concern is after building indexes on publication side will changes get replicated to subscription side or not? and also what is the best way to build indexes on...more >>

Hi, Currently, we have a table in sql server 2000 which has one column as int data-type and which is part of transactional replication we replicate this table to oracle. The oracle version is 9.2. Now we want to change the data type of this column to bigint what would be the best way to alt...more >>

Currently I am running 2 MSSQL SQL 2000 Enterprise servers running on Win2k3 utilizing SSL via "force protocol encryption". The systems are running fine with the exception of Snapshots and/or DTS packages that write to the local disk. When trying to get a snapshot to run for the local machin...more >>

Hello Everyone, How can I convert Miladi Date to the Shamsi Date? Thanks, Nassa ...more >>

Hi all, I have a problem in converting English Calendar into Iranian Calendar. How I can change that? What should I do? Thanks, Nassa ...more >>

I am using MERGE replication. Subscription is done @ 17 branch offices @ various locations. It running successfuly. Now I want to modify the table and want to add new column to the customer table. What should I do. Any changes made @ publisher side, how to apply @ subscribers side. Bes...more >>

Hi, I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the same machine. One instance is Publisher and Distributor and the other is Subscriber. When I try to use Windows Synchronization Manager to subscribe to the publication, I get this error: The SQL Server publication...more >>

I set up a Tranactional replication configuration and created a publication in SQL2005. When I set up the subscriber the wizard stated all succeeded. However, when I went to the Replication Monitor there was a error for the publisher. I went to the history for the agent and it stated the f...more >>

Hi, after upgrading a client within a Merger Replication scenario from MSDE2000A to SQL Express SP1 the subscription is no longer listed within the synchronisation manager. How to register the subscription within Synchronization Manager? (I know it is possible within Management Studio b...more >>

We have a high volume OLTP database of about 300 g and growing at anywhere from 5-20 g a week. We are running out of space and want to archive data older than 45 days off of the database to an archive database that could be used for reporting. The question is would replication be the best me...more >>

I have a question for merge replication. Scenario: Publication with 3 articles (tables A, B and C) and the sequence of changes at one subscriber are C (delete row), B (insert row), A (delete row) and B (insert row). Questions: 1) Does the merge replication agent keep this sequence when u...more >>

I have three locations each with multiple SQL 2000 databases that need to stay in constant sync with the other locations. Which is the best type of replication? Merge Replication or 2-way Transactional Replication? TIA, Kevin ...more >>

We are attempting to configure distribution on our new SQL Server 2005 cluster. Our setup is two failover clusters installed with SQL Server 2005 SP1 sharing a RAIDed hardrive array. We are trying to set up a basic push-subscription replication and we are failing at the point where distrib...more >>

Hi All, I have looked over BOL on replication; it seems a little lightweight. 1. Can someone recommend a good book on it? 2. Can you set replication with just two servers? 3. is replication set up at the db level…meaning I could have 10 dbs on the server, but I can set up replication ...more >>

I am currently moving from SQL2K to 2005 and am having trouble incorporating replication in 2005. First off, I've found myself in a loop where I have two publications that "don't exist" even though they show up in my Local Publishers list. I can't delete tables that are articles in those p...more >>

What is the difference between Bi-directional and Updatable Subscriptions Transactional Replication? Conceptually, they seem to be the same... or are they?...more >>

Hi, I want to use merge replication will pull subscription across internet. I have 2 computers with SQL Server 2005. Computer A is the main computer that will have the publication. Computer B will have a subscription to the Computer A publication. The distributor will be in Computer ...more >>

Hello, I have the following scenario. An application using SQL Server Standard Edition 2000 SP3 on the server side and clients using MSDE 2000A (SP3a) on the client machine. Since the client is offline quite often merge replication is used to keep the clients in sync. Now we try to upgr...more >>

we have 2 servers with similar tables and columns and indexes with fillfactor 0. My replication is very slow during daytime and comes to normal at night times.when i check the reads and writes both are more that 90 % high but when i check the page splits it shows nothing.what do i need to do to f...more >>

Hi everyone, hopefully someone here can shed light on this, I've run out of ideas.... I'm running two SQL2005 SP1 servers here, Windows authentication only, so far everything works fine. I'm managing them either through the Management studio on my laptop as well as directly. I want them...more >>

How in the world do you remove a table (article) from a publication. When I go into the Properties of the publication, Articles tab, the checkboxes are disabled for the tables last included. How do I re-enable the checkboxes? ...more >>

Good afternoon, guys and gals; In my all-MS-SQL2k environment, I use merge replication from publisher (server A) to subscriber (server B), and then as a new, identical publication from server B to subscriber (server C). When making a schema change to Server A using sp_AddMergeArticle, I can...more >>

I have 2 SQL Servers (2000), each to which data is written by local apps. This data is needed for reading on the other end by local apps. So I have configured transactional replication with publisher/push subscriber on each end. In terms of IDENTITY fields it works because tables on the sub...more >>

Can you setup a Transactional Replication from SQL Server 2005 database to a SQL Server 2000 database? If not, what else can be done to move data to a 2000 database (data warehouse, about 10 tables)? -- Thanks and God Bless, ThomBeaux...more >>

Is it possible to configure a SQL Server Express server as an updatable subscriber in the two-way transactional replication?...more >>

Can I use SQL 2005 Transactional Replication to use some custom transformations between the publisher and the subscriber ? Thanks ...more >>

What forum is a replication installation question best researched/posted? The problem I am having is that when I try to create a new local subscription I get a message that says replication is not installed. When I try to install replaication either via setup, setup -SKUUPGRADE=1, the gui ...more >>

I have an SQL server that I would like to set up with a remote copy of the database. I have researched ways to do this and determined that asynchronous mirroring and log shipping are the best options for me. I would be running over a WAN link (either a VPN or a point to point T-1). The data...more >>

Is it possible to configure transaction replication for a database from a SQL Server 2005 to SQL Server 2000 instance? Thanks, Thyagu ...more >>