SQL 2005 We're looking at replication for reporting - a pretty common use of replication. We also need/want to denormalize our tables in the replicated environment for speed purposes. My question is does Replication allow me to denormalize, or do I have to replicate the tables and then de...more >>

Hi, I currently have log shipping between a production and a reporting server running SQLServer 2000 but sometimes, because of the transaction log restore, the users are being disconnected before the report is created. I would want to change to transactional replication to avoid this probl...more >>

Before I got here a publisher with push subscriptions was removed. I can't delete the subscriptions at the subscribers. How do I remove these subscriptions? ps Thank you but please don't refer me to an article telling me to drop the subcription at the publisher because it doesn't exist ...more >>

hi all, Im running a snapshot replication on table. first, i gonna copy the entire table with a regional filter other than date second i'm going to replicate a days worth of data by using both the regional filter and date filter (getdate) to capture a days wordth of data. the publ...more >>

Is there a stored procedure or T-SQL that I can run that tells me if there are any conflicts on the database? I know I can read all of the conflict tables, but was hoping for something simpler. Thanks. David ...more >>

Environment: Database A with subscrition to a transactional replication pub... Datatase A is the primary in a database mirror configuration... In failover to Database B everything is fine except the subscription when in the failover mode... How do I configure this environment such that...more >>

When I add a subscription via a script, the subscription does not appear in the Replication Monitor->Publishers->'servername'->'publication' folder in EM. The script is being generated by EM. When I add a subscription via the wizard in EM, it appears in the above mentioned folder. Am I doin...more >>

HI! Sometimes with my testing pubs/subs schema (ddl) changes does not happen, even though it's set to true in the pub: compatibility is 90, etc... example: alter table [intra_events] alter column [eventDesc] varchar(600) this changes the pub db, but it does not propagate, also i che...more >>

Hello, I'm planning a merge replication that will eventually have about 9000 subscribers which all replicate over the internet. and I'm wondering if the number of subscriptions in a single publication is limited. Also, should I divide the subscription over a small number of identical publica...more >>

Can a 2005 server be set up as a replication partner of a legacy SQL 2000 (SP4) instance? Appreciate any assistance!...more >>

Hello, I have a replication table with composite primary key: sID- int (Identity) -No to for replication (or Yes For Replication) UnitID (char(3)) I would like to carry over the subscriber's sID to the server since the server has its own unitID. There is not conflict. I woulad like a...more >>

I have a merge replicated table with a composite pk. One field unique id, the other a float. SQL2Ksp4 and msde subs, anon. I get conflicts 'The row was inserted at SERVER but could not be inserted at SUBSCRIBER....Violation of PRIMARY KEY ...Cannot insert duplicate key in object 'XXX'.' ...more >>

Hi, I set up the transactional replication for our pre-product db server (EE2000 on Windows 2003 with 64 bit). The distribution database data file allocate size is 947MB and used 113.69MB, but the transaction log file allocation size is 2463.8MB and used 2421.5MB. The Log Reader and push a...more >>

Guys, When I ran this procedure (sp_change_secondary_role), I would get this error below: Server: Msg 14442, Level 16, State 1, Procedure sp_change_monitor_role, Line 30 Role change failed. Anyways, I follow Microsoft KB Q294397 by placing terminate = 0. EXEC sp_change_secondary_r...more >>

I have to create a number of indexes on the publisher database. These indexes are then replicated to the subscriber, and the distributor agent is taking many hours to delivered these transactions. Can I prevent these indexes from replicating, and then recreate them on the subscriber database? ...more >>

Hi We have a situation where the sql server backend is on the server but several laptop users need to disconnect and still be able to use the data. Can we have copies of say sql express on each laptop which can replicate data with the sql server when connected and still make the data availa...more >>

Hi, Can anyone point me to some details on how to setup a Pull Subscription? I have tried and get the same error each time. "Enterprise Mgr could not retrieve info about the Distributor or the Database". I'm sure i'm doing something wrong so a step by step guide is what I need. I have alrea...more >>

Is the above parameter only useful when using dynamic filters? ...more >>

Hello all! Is it possible to replicate table from MSSQL 2005 to MySQL? I have one table, which I would like to replicate to MySQL, but I don't see the option to do that ... is it not possible?! Thanks for all your input. Kind regards, Dejan ...more >>

I have a live, production db that I'd like to keep lean and mean for performance reasons. Every so often, I'll run a cleanup script to scrub out some older data in order to keep the tables from growing indefinitely and slowing my querying speed. But some employees would like to query ALL the...more >>

I am trying to set up a publisher and I get an Error 18482: Could not connect to server 'servername' because 'WEB1' is not defined as a remote server. I went to the Remote Servers where WEB1' is listed, although this server is no longer on our network. When I try to delete the listing, I ge...more >>

Deadlock encountered .... Printing deadlock information 2006-04-19 15:50:37.38 spid1 2006-04-19 15:50:37.38 spid1 Wait-for graph 2006-04-19 15:50:37.38 spid1 2006-04-19 15:50:37.38 spid1 Node:1 2006-04-19 15:50:37.38 spid1 PAG: 8:1:248401 CleanCnt:2 Mode: ...more >>

How can I determine if a subscription has loopback_detection set to true?? If I am doing bidirectional transactional replicaiton, do I need to have loopback_detection set to true on both subscriptions?? Larry... ...more >>

We are getting the error " Could not connect to server 'DISTRIBUTOR' because 'distributor_admin' is not defined as a remote login at the server." It was working fine. Mistake happened were tried to delete the remote server through enterprise manager. It wouldn't let the remote server drop b...more >>

I am setting up log shipping for SharePoint databases. The primary and secondary servers are SQL 2000 Ent. w/ SP3a, and connected over a WAN. I am testing failover/failback processes and have questions regarding failback. I have been unable to find sufficient documentation on the failback p...more >>

I am attemting to write a TSql script that dynamically plugs in the linked server name in based on the value in @Location. In this example the linkes server name is Rouse03 I wrote the following script <---------start--------------> DECLARE @LOCATION AS char(2) SET @LOCATION = '03' DECLA...more >>

Hi, I try to implement a warm standby server based on the transactional replication in Microsoft SQL Server 2000 (SP3). Is there any way I can retain original timestamp values from a replication publisher (production) database in a subscriber (standby) database and at the same time have times...more >>

Hey Paul, Thanks for the answer. On writing: "Use Master go Select @@Servername" I got the following output: STUDENTLT ------------------------------------------- what should i do in this case? According to me it should be STUDENTLAP00493. I s...more >>

Hi, we currently have an install of SQL 2000 in our UK office which performs merge replication to three other offices in Thailand, Spain & India via a vpn. The whole setup has been working great over the past couple of years until.... Our ISP in Spain went BANG and they lost their Internet con...more >>

I am getting this error: " SQL Server Enterprise Manager could not configure 'STUDENTLAP00493' as the distributor for 'STUDENTLAP00493'. Error 18482: Could not connect to server 'STUDENTLAP00493' because 'STUDENTLT' is not defined as a remote server. " Can anyone throw some light...more >>

I was searching for solutions regarding setting up merge replication within LAN workgroups without domain. Is this possible in MS SQL Server? Is it true that replication require active directory to work? Therefore require domains environment? Thank you...more >>

Morning All, I used to use the Merge ActiveX control under VB6 and use withevents to get information about the Agent replication process. Is this still possible under VB.net to use the new RMO objects and get events. I have and a look at some examples and they all seemto have to refresh to ...more >>

I have been able to replicate between SQL Server 2000 to SQL Server 2000 inside of my workgroup. However, whenever I try to Replicate Data between SQL Server 2000 and Adaptive Server Anywhere , I am getting the error "error 14094". Has anyone done anything similiar to this? Any help would be...more >>

Shouldn't the Merge agent stay started once you select "Start Agent" I had an issue with one of my servers that stopped my Merge from = running, and now that I have reinitialized, the Merge Agent doesn't seem = to stay started. Perhaps I am wrong & thinking in terms of Trans. Repl, = but I co...more >>

Hi there ... Here is the situation. * PUB is the publisher, SQL 2K, which is on the Internet, behind a firewall that is allowing 1433 and NetBIOS traffic from me. SUB is the subscriber, SQL 2K. * The publication and the subscription are all setup. They are set to use SQL security, ...more >>

We are using SQL 2k with SP4, and using push replication. The distribution database and the publishing database are on the same SQL server computer. We are doing daily backup on the distribution database. If for whatever reason, the distribution database becomes corrupted, is it ok to resto...more >>

Hi, I'm working with a merge replication All the subscribers are salesman that work with their laptop On each Lap Top we install MSDE service pack4 Now which user account should we use to run the MSSQLSERVER service and SQLAGENT service if the salesman work disconnected of the network ...more >>

Hi, after some days that I've been for vacation, after coming back becuase of the problems with link one of my replication of a databases became inactive. I'm using NoSync intitialization from: http://www.replicationanswers.com/NoSyncInitializations.asp Before this happened to me, what I d...more >>

Hi All, I have a problem, I have a database in a SQL 2000 SRV that I need to replicate with a Notebook where is installed MSDE 2000. The Notebook is non link to the Domain but it use a Workgroup Access to browse the LAN. When I try to use a PULL replication it give me an access denied error, ...more >>

i am running this wizard and when i get to the page in the wizard for Snapshot share access it wants me to point to the network path of the snapshot share. where is this folder located at by default? i have read through documentation and have not been able to find it. any help would be mu...more >>

Hi, We are using SQL 2K with SP4. Recently I tried to detach a database and for whatever reason, it is marked for replication so I can't detach or delete it. How can I change its 'replication' status to none? There is another database marked correctly for replication so whatever sugge...more >>

Running Win 2003 & SQL 2000 Have Trans & Merge Replicaiton There are bunch of system views named like dbo.syncobj_0x4133334337354442 in one of my production databases. I am not sure where they came from, when or who uses them if anyone. Are these SQL Server views used by the system itsel...more >>

Hi, I have set up SQL Server 2005 Express as a subscriber. In the setup process I was not able to schedule the time interval for merge replication. How can I accomplish this? Thanks Ben...more >>

Can anyone explain why I regularly get errors complaining about the identity range being exhausted, with the "helpful" suggestion that I run "sp_adjustpublisheridentityrange" when the identity ranges are clearly NOT exhausted? DBCC CHECKIDENT shows the various subscribers have different cur...more >>

Question: Is it safe to reinitialize a subscription if there are unresolved conflicts from the subscriber? What happens?...more >>

Do conflicts that show up in the conflict viewer somehow automatically resolve themselves after a default time? It seems as though I get a number of strange conflicts all the time, and quite often I cannot resolve them due to an identity range management issue... I log the info, and spend ...more >>