Thanks in advance for any help you guys can provide... This is the setup I have: a) SQL Server 2000 Standard running on Windows 2000 Server at multiple co-lo sites b) No VPN between the sites I would like to be able to do replication between the sites so if a value is changed at any site i...more >>

Heya, I have table STOKMOTION with field described as; [INCREMENT] [numeric](18, 0) IDENTITY (1, 1) NOT NULL Now I want to make add NOT FOR REPLICATION statement and tried below; ALTER TABLE STOKMOTION ALTER COLUMN [INCREMENT] [numeric](18, 0) IDENTITY (1, 1) NOT NULL NOT FOR REPLICATION ...more >>

With the distribution agents the default number of retries is 10 and I'm not sure what the default interval between these retries is. My question is this, is there a way to change the retry number or the interval between retries, preferable both. Thanks in advance, <CARL>...more >>

I have successfully established a merge replication between tow SQL 200 servers with SP2. One replicated tables (InvoiceDetails) have a relationship and a foreign key with another replicated table (Invoice) After a while I noticed that some records at the subscriber table (Invoice Details)...more >>

Configuration: Two Clustered Compaq DL760's, Active/Active cluster Advanced Server 2000 SP4 SQL Server 2000 SP3 Brand new installs Problem: Configured Publisher and Distributator on node 1 (Production database) Pull Subscription on Node 2 (Reporting database) Everything is green until t...more >>

We have two servers, we have nor dropped the replication between the two, and rebuilt it from scratch. It successfully creates the snapshot - no problem. However when I start the Distribution agent to activate the snapshot and fill the tables etc, it gets so far into running the automatic...more >>

I am getting the following error while applying my intial snapshot. The process could not bulk copy into table '"TNT_RateType"'. Unexpected EOF encountered in BCP data-file (Source: TNTDWSQL01 (ODBC); Error number: S1000) ----------------------------------------------------------------------...more >>

Hello, I've Merge replication set up on SQL 2k SP3. I've Identity range of 100 with 80% thershold on both publisher & subscriber. What is the best way to change Identity ranges & thershold?. I tried doing it from Properties of publication but looks like it is not reflecting properly. ...more >>

Hi, We are starting to add replication to our database/application. I'm trying to make a decision about whether or not to use GUIDs as the primary key in our tables. Currently, we use an identity field. This is stored as a foreign key in other tables. I am wondering about other's experience...more >>

I am Unable to Remove Publications after a Failed Distributor. I have tried with scripts and with enterprise manager. I get the error: Unable to connect to Distributor That is becuase it is dead and I am trying to point them at a new one. Thanks for the help...more >>

My client has a server and a couple dozen laptops that connect to the server over a sometimes unreliable wireless Internet connection. I would like to use replication to sync up their data, but I'm concerned about what might happen to the data if the connection is disrupted during replica...more >>

What is the best way to replicate data with heteorgenous source? I need data to be capable of updating on both servers. Here is the layout. One SQL2k box, One DB/2 box. do i use merge? transactional with updates? two phased commits? what are some of the general guidelines and concern...more >>

Hi! We set up a merge replication on a WIN2k Advanced Server SQL2k SP3 with 80 tables and horizontal filters. There are 50 clients WIN2k MSDE SP3 which synchronize via pull subscription. The central database is changed every morning, so table msmerge_contents has 250000 rows right now. ...more >>

The specified subscription type is invalid. The specified subscription type is invalid. (Source: Merge Process (Agent); Error number: -2147201020) ------------------------------------------------------------------------ ---------------------------------------- -- Posted via http://dbfo...more >>

Hi All, I've got a merge publication in which I audit replicated tables. Essentially there's an insert/update/delete trigger on the table which keeps a changelog in an audit table. While replicating we had conflicts with rows being entered into those audit tables - apparently the repli...more >>

Hi All, I'm trying to filter a table that is a join between two other tables (filtered too) . For example: a table A, filtered on the value of a specific column (A.col1='x') a table B, filtered on the value of a specific column (B.col2='y') a table C, with a FK on A and a FK on B, filtered ...more >>

We have: SvrA as Publisher (database: DBX) SvrB as Distributer SvrB as Pull Subscriber (not updateable, database: DBXRPT) This transacational Replication on an 8 minute cycle. There may be some changes to the Primary keys on several databases. My questions is are: Do we need to drop Publish...more >>

Sql 2000 --> Sql 2000 =20 1. Replicate database to same server 2. In the future, we may replicate to a different server I am charged with replicating our production database, for the purpose = of running reports, connecting via Microsoft Access, etc. =20 They want this database to be real...more >>

Hi, I'm getting the "The process could not connect to Distributor" error when trying to do a pull subscription. Here is my setup. Machine1 set up as publisher for a snapshot replication of entire database. Machine2 set up as the distributor. Machine2 also set up with a pull subscription to ...more >>

We have two SQL 2000 server Running on Win2K server, configured for Transactional Updatable Pull subscription The scenario is, when there is a network problem between the 2 servers (Publisher cum Distributor and Subscriber ) the distributor agent tries for atleast 10 times to establish connectio...more >>

I am trying to make a table change that is a merge replicated article. I thought in SQL 2000 that this change could be made without disabling the subscribers and dropping the article. I am getting an error that says object is part of replication.. Is there a way to make the table change wi...more >>

Goog morning, I would like to know how I can link an Oracle Server to a SQL Server via DTS Packages. Is it possible ? Thanks for your answers Julien ...more >>

I have set up a server with a publication of a very large database. A backup server needs to retrieve the data and do some massive calculations (which isn't really relevant). On the backup server I've created a subscription to retrieve the database but I get the following error: Message: The p...more >>

Anyone out there had experience on transactional replication setup? The error message I got is "The process could not create file '\\SERVER\C$ \MSSQL7\ReplData\unc\PUBLICATION\20030805103246 \cofrtbase.sch'. " - Access Denied cofrtbase is a table that I tried to create a publication wit...more >>

Hi experts, We have several tables that are in a staging database for processing reasons. When processing is done we migrate data from one database to another. My question is what is the best way of doing this? Thanks in advance!...more >>

Problem Description : I have transactional replication with updateble subscribers.Subscribers passing their updates to publisher using MSMQ (and not by default SQL server mechanism).Every thing have worked perfect untill i have installed SP3a. Now no updates are reaching the Publisher qu...more >>

We have several databases running on our SQL Server and replicate the most important ones to a second server in seperate building (Some using Transactional, some snapshot). Within the last week, we've noticed that each of the replicated databases has had a number of views created with ...more >>

We have hit a limitation on replication of 255 columns in a table. is this a hard limit requiring the splitting of tables or is there a configuration option to increase this (we need 350 Columns)...more >>

I have a push snapshot replication that connects to an outside subscriber on a daily basis. At times, the distribution agent is unable to connect due to network issues. Whenever this happens and I try to restart the synchronization process, the distribution agent will hang and eventually give me th...more >>

First of All, sorry for my poor english ;) I have a SQLServer 2K (Ent) in a W2000, and a client with W2000 & MSDE. I have defined Publisher/Distributor on Server. Merge Publication. In Client, MSDE and suscription. Both running SQLAgent In Merge starting, fails Error -2147201001 : ...more >>

I have configured transactional replication with a pull subscription. The snapshot initialized and I now receive an error on the distribution agent stating: "The process is running and is waiting for a response from backend connections". I have done the follwoing to try and alleviate the problem:...more >>

Hi, When I imported data thru DTS (Bulk Import) on published database in one of table it didn't replicate to subscriber. That means on this import replication trigger didn't fired. Do I have to do anything extra? Any suggestion welcome. Thanks Nilay ...more >>

Hello everybody. I have encountered a peculiar problem trying to setup a merge replication between two SQL Servers (2000+SP3). The steps I am performing are as follows: 1. Run "Wizards > Configure Publishing and Distribution Wizards" to enable publication on the future publisher. Here everyth...more >>

We have an application with a number of tables that have user changable data and 2 columns that are updated automatically whenever a user changes data to indicate when and who changed the data. We are in the process of setting this application up for replication, and it looks like the ModifiedDa...more >>

Hi there, Our merge replication did not merge the data, which is transfered in the subscriber through DTS. Do you know how? Thanks Nathan...more >>

thanks for the later answer, now my replication only uploads to server, but not downloads to the suscribers; please, i need help thanks Manuel ...more >>

Good morning everyone... My server is currently configured to backup directly to a tape drive. My question is: Can I stil use log shipping? I'm not sure how the shipping works physically.... will the transaction log backup write to the tape and into a folder for shipping at the same ti...more >>