Hi, Our subscriber crashed and they had a quite a bit of work captured after the last synch up to the publisher. We salvaged the MDF and LDF. I have tried attaching this subscriber to a new machine which worked fine, now I want to synch that data with publisher. Is this possible? I cant se...more >>

Has anyone successfully implemented Bi-Directional Transactional replication? The documentation on BoL is very limited and there are not too many info available outside too. We are planning to have active-active SQLServers, that needs dynamic transactional replication. I would really appre...more >>

With user defined datatypes (UDT) you can attach rules which limit the data that can be inserted into the field that is tied to the UDT. The problem with using UDT's with replication is that if you need to change the type due to a rule change it causes a lot of pain. Say for example you have...more >>

I have the following need and I would like to know is Replication the way to go about it. I have 12 GB OLTP database with lot of activity on a daily basis. I am being asked to come up with strategy to keep a backup of this database. In case of failure (either the server or hard drive or any...more >>

Hello. We have one distributor and about 20 subscribers. Yesterday we have added some columns to the schema. After synchronization almost all subscribers did it without problems. But one could not make it with error: Invalid column name 'compensate_for_errors'. (Source: PLANTBRK (Data sour...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hi, I am trying to setup replication on an SQL Server 2000 database. SP3a has just been installed. The Snapshot Agent fails during Replication with the following error: Preparing table '[dbo].[tblRecordStages]' for merge replication SourceTypeId = 5 SourceName = WIN2KVMWARE ErrorCode =...more >>

Hello All - I have a problem with push merge subscription. The publisher/distributer reside on same host with several clients connecting for merge replication. The startup of one of the merge agents fails. The error message "Login failed for user 'dbApp'. Reason: not associated with a trus...more >>

Hi, I am using merge replication. The subscriber is using pull subscription. The problem is this; a subscriber machine has crashed. The problem is how do i delete any evidence of the subscriber on the publisher, so that i can create this subscriber again, without getting this error: "error ...more >>

Hi, as soon as I enable the replication, I get an red X on replication Monitor\agents\log reader agents replication Monitor\agents\distribution agents publishers\machinename I use to replicate on this machine but since I disabled it once, can't re-enable it. SQL 2000 sp3 thanks ...more >>

Hello. I'm looking for a way to remove data from a merge replicated database that would be filtered out if it was synchronized for the first time today. In addition, I don't want the new rows to be deleted from the publisher's database. Let me explain. We have several tables that look sim...more >>

Dear All When I make synchronization some commands fails due to relationships, key violation, ... How could I skip those commands and eliminate it from the distribution database? Ahmed ...more >>

Under the conditions outlined in the kb article, we also get a failure in sp_replaaddcolumn: sp_repladdcolumn 'table_name','columnname','bit default 0','none' GO Server: Msg 207, Level 16, State 1, Procedure upd_7F7880ABD616444FAD031E1A0817242C, Line 72 Invalid column name 'columnname'. ...more >>

Dear Friends I am getting the following problem in merge replication. The merge process could not retrieve column information for table 'dbo.SAL05'. (Source: Merge Replication Provider (Agent); Error number: -2147201016) ---------------------------------------------------------- -------...more >>

Dear Friends I need to change the column datatype from Real to Float as now i am facing the problem when my user put value 140189.14 it is accepting only 104189.1 Please note that i have the same table in merge replication and i do not want to stop the replication. Please guide me to ...more >>

Dear Friends Please suggest where i can get the status for the replication ( Same is working or in failed status ). What i want to do is when the user is taking the INVOICENUMBER from the application it should check for the status of the replication if the same is working or not. Your...more >>

Dear Friends I want to delete one article from the current Merge replication i have use the sp_dropmergearticle but it is comming up with the error that the ARTICLE CAN NOT BE DROPED AS THE SNAPSHOT OF THE SAME PUBLICATION IS ALREADY APPLIED. Please suggest how I can do the same. T...more >>

Hi, When I delete subscriptions and publications and disable the replication, the check constraint for identity range stays in subscriber for tables. Then I have to manually drop or disable them. Is it an expected behavior or there's something wrong in my work? How can I have them removed autom...more >>

Dear All I'm using transactional replication and I have a table already published and it was synchronize correctly. I'm using the option 'Create the stored procedures during initial synchronization of subscriptions' on this article I added 5 columns to the published table and added ...more >>

Can I do replication to copy tables in one database which was not create by me to another database? ...more >>

If my publications are not actively receving any changes on the Publishing end, will the latency increase ? If there are no transactions/commands being pushed to the subscriber , then how is latency calculated ? I have setup replication and its been idle for a few days now and the latency shows ...more >>

I have 1 Publisher Server that uses itself as the distributor for 3 different publications. The publications are all transactional and all publications use Push subscriptions to replicate their articles. I have 2 Subscriber servers. Each subscriber server receives 3 push subscriptions, 1 f...more >>

Hi, I have two SQL Servers that do not have any connection to each other. Is it possible to transfer the snapshots and later changes(merge replication) by using something like a removable media(CD or..)? It seems silly because we are in 21st century but there's particular situation that thes...more >>

Hi, I am setting up a merge replication of a large database across internet between two servers which are located in two geographically different location and can connect to each other with a fast T1 Connection. The purpose of it is to have a hot backup site available for the DB. The proble...more >>

i am currently trying to set up transactional replication from a database which is on a cluster. however, when I attempt to specify the location of the snapshot folder (in this case : \\server1\v$\Program Files\Microsoft SQL Server\MSSQL$instance\ReplData) it claims that this is not a valid pa...more >>

HI We have 1 Central office “Corporate Office” and three branch offices. We are in process of developing an Order Management Application, Every branch will enter Inquiries/Quotation/Orders into application and at the end of day we want all data entered at every branch to be available at corpo...more >>

Hi All: What is Bi-Directional Transaction Replication? How is it different from Merge replication? Thanks, Anukul ...more >>

I don't know if an 'official' buglist exists (it would certainly be useful), but at least 3 of the issues here have been causing problems in the setup I'm responsible for... A list of the bugs that are fixed in SQL Server 2000 Service Pack 4 Beta http://support.microsoft.com/default.aspx?s...more >>

Hello, How can I config a merge agent to automatically start when the server restarts. After a shutdown and restart of the server, no merge agents are started automatically, but show the message 'job cancelled due to stop job request'. The SQLSERVERAGENT service is configured to start autom...more >>

Building a second merge publication from a db, I'm getting an error 'Invalid Column Name XXXXX' on gernerating the initial snapshot. The column definitely exists. Anyone seen this behaviour before and maybe offer some guidance? ...more >>

I am experiencing a weird problem with an INSTEAD OF DELETE trigger. I use this trigger to delete some child items in other tables before I delete the parent item itself. For some reasons, I can't use cascade deletes. The trigger looks like this: CREATE TRIGGER [TriggerName] ON [TableX] ...more >>

Please help. We do transactional publication to replicate SQL 2000 database from our internal server (Win2K server with SQL 2K server) to our web server (Win2K server with SQL 2K server) hosted by RackSpace. There is no bandwidth issue bewteen these two servers. There is no firewall rule bl...more >>

server a that contains database a, needs to be replicated to server b, the data base is dynamic, what is the best method to accomplish this?...more >>

Hi All: I have 2 sites, one here in India & one at Montreal working on same database, hosted here (India), using ASP Application. The link is dedicated over WAN. Now I want both sites to access their own DB at their local ends (structure being same) & then replicate/snycronize both Databa...more >>

HI, The situation is like this, merge replication is setup on server(Publisher), and 4 clients machines and these are subscribers. I have two table with primary key and foreign key relationship. Both the tables have primary key with Uniqueidentifier column. First uniqueidnetifer column ...more >>

HI, The situation is like this, merge replication is setup on server(Publisher), and 4 clients machines and these are subscribers. I have two table with primary key and foreign key relationship. Both the tables have primary key with Uniqueidentifier column. First uniqueidnetifer column ...more >>

Hello. I am using an MS SQL Server 2000 with service pack 3. How can I replicate indexes with EM replication wizard? Is it possible in snapshots , merges and transactionl replications? Thank you so much....more >>

Currently I am using SQL Servers in LAN. But now I want to connect to SQL Server residing in office in another city. I donot want to use Web based connectivity. And just want to dial (56k) in that SQL server computer via Remote Access and get the required data for complex report. Please ad...more >>

I need to add a column to a table that exists in two publications. A couple weeks ago I added the column using sp_repladdcolumn to ONE of the publications. I realize now that I should have added the column for "All" publications. Can I still use sp_repladdcolumn to add the column to table...more >>