Hi Guys, can anyone tell me a good open source project or tool that I can use to sync data over the dial-up conection different two SQL Servers? I tried the replication it's giving wired messages. Please help Thanks, -Aruna ...more >>

hi, is using delete existing table and re-create one the best choice? I am thinking delete and re-create would take longer and drop the permission on the object as well. is there any other options can insert the newest data using transactional replication without dropping the table firs...more >>

Hi, My friend, I got a replication problem. the message is: Cannot insert duplicate key row in object 'MSmerge_tombstone' with unique index 'uc1MSmerge_tombstone' The statement has been terminated. Would anybody help me to solve this problem. Regards Jackson ...more >>

Hi, I have a transactional publication setup that has no automatic schedule of it's distribution agent. The agent is started from an application as a "Publish" feature that is used when the user wants to commit the data to our production systems. It seems as though the combination of the...more >>

Hi Friends, We used SQLMERGXLib.SQLMerge in our VB.NET windows client application for calling sql server 2000 replication. Now we need to move to sql 2005 for using the http file transfer feature. The SQLMERGXLib.dll comes with sql server 2000. I try to find out what is the equivalent l...more >>

I have this little piece of code that works in VB.NET but NOT in ASP.Net and was wondering if anybody can help. In the part of the code that goes thru each group in the server group to get all registered servers the code JUMPS over it as if it doesn't see any. Also, if this helps, when I try...more >>

I have a database with 3 added filegroups/files. The restore with move, moves the logical filename to a specifiic physical file. Once restored the db objects should be restored to their proper filegroups. Once I run the snapshot, can all of the schema and data be pushed to the PRIMARY/DEFAULT ...more >>

I have a TSQL script to add daily tables to replication and then run the snapshot agent to distribute them to two subscribers. The script executes without errors, but when I check the running jobs for each server I see the following: JUST AN EXAMPLE Job1 'Category' REPL-Snapshot Job2 'Categ...more >>

Hi, I would like to make the concept clear that if i have two individual servers let's say one in CA and one in TX. i want them to be able to syn. data (look at each other inventory data), I should use Merge Replication. If I want to sent CA and TX data to headquater in NY, I should use ...more >>

hi all, i need to drop some tables from a merge replication, i have a publisher that is also the distrubuitor, and 2 subscribers, i have 2 tables that i no longer need to replicate, my articles are set to on name conflits leave the current table unchanged. Whats the best method of dropping the...more >>

After studying Log Shipping last week and reading up on it, it appears to be the best solution for us. I am using to test servers to get it up and running before releasing it to production. I upgraded both servers from Standard to Enterprise edition. This allows me the capabilities of using...more >>

Hi, I am at the head office of the company and we have 9 locations nationwide. We don't generate any transaction in the database in the head office. We only collect data from other location. I am asked to transfer the Inventory system about the partnumber and quantity on hand to the hea...more >>

I have a centralized database (server A), and two remote databases (server B & C) all with a copy of the same database with a table with user entered, primary key like ProductID. There is a possiblity that the same ProductID gets entered into both B & C (which is ok). I create a snapshot of B...more >>

hi, Can someone tell me the snapshot replication is actually to copy an article from a publisher to subscriber? If so, is that the same as using the DTS to copy data? If tables in Subscriber have foreign key relationshiop, i am not able to "delete the existing table and recreate it", does...more >>

I have a series of NT4 systems that I need to set up replication on. They have sp 6a installed on them I have done a clean install of SQL 2k Server then added sp3a Setting up the publication provides no problems, but when I try to run the snapshot agent, I have been recieving problmes (differ...more >>

I have some questions about how the merge-agents deal with batches and its effect on the order of merge replication. As described in http://support.microsoft.com/default.aspx?scid=KB;EN-US;307356 the processing order of the merge agent can result in foreign key conflicts when Parent and c...more >>

I have some questions about how the merge-agents deal with batches and its effect on the order of merge replication. As described in http://support.microsoft.com/default.aspx?scid=KB;EN-US;307356 the processing order of the merge agent can result in foreign key conflicts when Parent and c...more >>

I have a simple snapshot replication set up. I was getting the following error (with 650,000 rows): The process could not bulk copy out of table '[dbo]. [syncobj_0x000000000000000]'. I/O error while writing BCP data-file (Source: ODBC SQL Server Driver (ODBC); Error number: 0) I have red...more >>

Dear helper, I have a database that running on SQL Server 7 and it has been published for replication for a period of time. After that period i remove the publication and still the database running correctly without any problem.Then a change in requirments happend, as a result i need to dro...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Hi, I'm attempting to setup transactional replication between ServerA and ServerB (both SQL 2000 Enterprise Edition). ServerA is the publisher (build 818). ServerB is distributor and pull subscriber (sp3 build). I've previously setup replication between the two - which worked perfectly. Thi...more >>

Hilary, The webcast of yours http://support.microsoft.com/default.aspx?kbid=893437 doesnt seem to work. Have you checked with MS about it ? Also the transcript redirects to a page not found.. ...more >>

Is it possible to replicate from 2 tables @ the publisher into 1 table @ the subscriber using a join ? ...more >>

I would to ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, Server Options) are consistent and repeatable between multiple database instances(ie: a test and production copy of a database). What is the best I can do?...more >>

Is it possible to create distribution, replication... from script? I would like to do this on a new sql server. Is there a macro to record the step I do and I can bring that to production server and run it? Thanks. ...more >>

Hi All How can I checked the publication are subscribed to all subscribers? is there any stored procedure or method to do this? Thanks alot Tolga -- Message posted via http://www.sqlmonster.com...more >>

Hi, Thanks to Hilary for replying to my last post. I am setting up a very simple Snapshot replication on two servers using a push subscription. I can create the initial snapshot and distibute this successfully. The replication monitor in enterprise manager, however, shows errors again...more >>

Hi, I am in need to change the publisher server IP . Now merge replication - push subscription is being used. Distributor is same as the publisher. (1) Does it impact the publication? (2) In case in future i want to change the subscriber IP ,do I need to create a new subscritpion ? (3)...more >>

Hi, When I use merge replication which side will the polling take place 1) At the subscriber end 2) At the publisher end Is this configurable ? What is recommendded ?...more >>

Can merge replication be setup with a subscriber who is not part of the distributor domain? I'm trying to test some replication using anon merge replication with TCP. My PC is not part of my server's domain. My output file reveals that my SQL-Agent on my subscriber is submitting my current...more >>

Greetings: I am working on a setting up an alternate synchronization partner, and getting an error. Bear with me as the explanation of what I have done so far is long. We have about 75 customers with about 100 pull subscriptions using about 20 publications in merge replication with Sql ...more >>

Is it advicable to use DTS package as a tranformation media in transactional replication or should transformation be done at Stored Procedure level on Subscriber? Under what circumstances it will be a good idea to use DTS package. Thank you very much....more >>

We have a DTS package doing some transformation in Trasactional Replication. Now, I want to add a new table as a part of the replication without shutting down replication. I can add it through sp_addaarticle and sp_addsubscription. However the DTS can't be modified as one of the component in D...more >>

What are the "side effects" of giving existing uniquieidentifier columns the "ROWGUIDCOL" property? eg. ALTER TABLE tableOwner.tableName ALTER COLUMN columnName ADD ROWGUIDCOL Is there an easy way to remove ROWGUIDCOL from a column? Thanks....more >>

Can I have 2 (distributors) distribution servers for 2 different publications on one publised db? (I doubt it is possible, my information says only one distributor per published DB, due to logreader, but I have to ask in case I have a misunderstanding of how replication works) Scenario would be...more >>

I'm trying to publish a database and when I get to the end of the wizard, I am greeted by this message: SQL Server Enterprise Manager could not configure 'SERVERNAME' as the Distributor for 'SERVERNAME'. Error 18483: Could not connect to server 'SERVERNAME' because 'distributor_admin' is no...more >>

We are wanting to implement a solution so that if our main web server database server fails, then a backup server kicks in automatically. We already have all of the hardware in place and the only task left is to figure out the best method of having "as close to real time" database backups as...more >>

I am using snapshot replication which is failing due to lack of memory on the publisher (currently 1.7Gb). How much memory is usually required?...more >>

Dynamic Snapshot and filtering data with the function "Host_Name()". Question: Can we only define one "-hostname xxx" on the subscription? Because our subscribers need more then one "-hostname xxx". Example: Salesperson "xxx" works with the filter "-hostname xxx" an get only "xxx" addres...more >>

Is it possible to separate out multiple publications on same publisher to different distributors in Transactional Replication? For example: Publisher is Server A Databases Are: DB1, DB2 and they have couple of publications I have one remote Distributor say Server B that currently has a dis...more >>

Does anyone know how to change a local pull subscription in merge replication to a global subscription? I tried using "sp_changemergesubscription" which is executed at the publisher according to BOL and set a priority other than zero, but I get an error that says a local subscription cannot...more >>

When trying to create a Linked Server using MS Sql Server 2000 (8.00.818), I encounter a SQL Server error stating: Error 15028: The Server Darq111 already exits. The Darq111 server does NOT appear as a Linked Server but does appear as a Remote Server. On the 30 or so remote Sql Servers ...more >>

hi, our app works in a multi tier model to provide inet connectivity now a customer wants to be able to keep working even if the inet is down or the main server is down so the obvious solution is to use replication so: 1) what is the best place to start understanding what is involved 2) al...more >>

Hi All, I'm trying to use msjro.dll (JRO library) to perform an on-demand merge replication of Access 2000 mdb with SQL Server database. I'm using vb.net to go against the jro. Below is the function that supposed to do the job (according to this MS KB article: http://msdn.microsoft.com/libra...more >>

Hi All I have already checked the answers in discussions to find a solution for my problem but I could not.. I am using Trancation Replication for my customer. There is one server (Publish) in a city and 5 more Subscription in different citys. We are only replicating one Table, that is call...more >>

Hello, I hope someone can help me answer some questions about replication, to solve my problems in a project. I'm involved in a webproject which uses a replicated SQL Server 2000 database. The source database (which is created by a 3rd party, so maintanance is not in our hands) contains tri...more >>

Hello, Goal: Maintain a copy of two of our live databases from server A on server B that are updated hourly. The databases on server B are intended to be read from, not updated. Database 1 is about 500 MB, database 2 is about 3.8 GB. Problems: 1) Transactional replication requires a pr...more >>

Hi, I have a database that is replicated. There seem to be a lot of system generated indexes on the tables. These are not primary or foreign key constraint indexes. It looks like COLATE constarint is being added to the columns. e.g. This a create table script pulled form Enterprise manager....more >>

Hi, I am dealing with merge replication between local & remote server (20 databases). Now 105 tables are in replication in each databases. I am in need to replicate non table articles also. (1) Can I replicate stored procedures, views & functions ? (Only if any changes made in ab...more >>

I have a snapshot that take 1 hour and the distribution agent takes 3 hours to apply. I need to make this go faster. I have been reading about -maxbcpthreads and -useinprocloader but not sure where to put these commands. Do I insert them in the snapshot and distribution agent at the run agent ...more >>

Hi NG, I have a question regarding the restore order of databases in case of total desaster on the same server. I use KEEP_REPLICATION. 1. master 2. msdb --> Stop all jobs in msdb 3. distribution 4. replication database Is these sequence OK? thanks in advance Thomas ...more >>

Hello, I have a merge replication with one alternative publisher and 4 subscribers. I'm getting this error only in the alternative publisher agent: The process could not enumerate changes at the 'Publisher'. Details: The process could not enumerate changes at the 'Publisher'. (Source: Merge ...more >>

I have a transaccional replication in a server with sql server 7, the publisher is a server called serv1 and the subscriber is a server called serv2, well until a few days ago it did not have this problem but from one day to other the snapshot agent started marking this error: Server execution...more >>

A customer of mine using our application software with replication reports a couple/three tables are very large. This is impacting the MSDE 2-gig limitation. ms_merge ms_contents ms_genhistory ms_replinfo ms_deleteconflicts. How may I reduce the size of these individ...more >>

Can someone please describe what this is and how I adjust my dist cleanup agent retention times for it. I know the basics, but when I go into MSdistribution table there are alot of fields that seem similiar (ie: current_delivery_rate, current_delivery_latency, delivery_rate, delivery_latency)....more >>

Hello sometimes for communication problems, the replication stops and we need to Start Synchronizing again. Is there a way I can be notified when this happens. Because usually I found out that replication stops when users start calling that they don't see the data from the other sites. Is there ...more >>

I have a problem where the subscriber to push subscriptions has taken over as the primary database server because the publisher went down. Now I want this new server to be a publisher. Problem is that when I try to create a subscription, it thinks it's involved in replication as a subscriber...more >>

Hi, I am encoutering a problem in our application. We have a product which operates on 6 databases in SQL Server (Or can be oracle).There are few (4) tables in each of these database which has same table design and needs to have the same data. Problem : The DML statements are carried out...more >>