Dear All We have developed an Order processing Application, We have Head Office and three branch offices located throught the country, Each brach office has its own SQL server installed , at the end of day we want to gather all branch offices data into our head office sql server , I have pl...more >>

Hi I am developing a smart client application. I have to push the client side data back to the server side and vise versa what would the most secure way of doing this -SQL SERVER MERGE Replication - Web Services ? Anyway else Could anybody help me out ...more >>

just wondering would it generates trigger for some tables when those tables doing merger replication. using sql server 2000 Cheers nick...more >>

Is am running SQL 2000 SP3 on a Win 2000 box. My msdb is marked suspet. I ran sp_resetstatus and restarted SQL and the dB is still suspect. I found an article that recommends.... One approach would be to drop & recreate the msdb databases (see instmsdb.sql and instserv.sql in the c:\mssq...more >>

Hello, I'm wondering what type of replication (if any) is best suited for a publishing database that has a tendency to change schemas rather often. I'm under the impression merge is best for me, but I'm not totally sure. I'm not talking huge changes... just things like adding columns, tables, ...more >>

I have a Db which is both a transactional subscriber and publisher. I need to move the .MDF and LDF files to another drive set. What is the best way to do this? Thanks. Sherpa ...more >>

Hello, I am wondering what I am doing wrong or if what I am seeing is normal behavior. I have manual log shipping in place (via SQL LiteSpeed). We have a replicated database log shipped to a DR server in another location. When I fail over to the DR site, I can still see the publications on ...more >>

Hi, Over the weekend I was taking advantage of system down time and made some changes to my merge replication database. The changes were all successful until this morning I get users who are getting duplicate key error messages. I have verified that the duplicate key is causing the error. ...more >>

When I run the following sp on the remote distributor it works fine. When I go to run it on the publisher I get the error message that is below as well. sp_adddistributor @distributor = 'MyDist', @heartbeat_interval = 30, @password = 'password' error: Server: Msg 18485, Level 14, State 1, P...more >>

Hi All, Could someone point me to a white paper/best practices on how to move/update data from test sql server to a production sql server? Both of the server have the same schema. I would like to know if there is a way to synchronize the two databases. Would SQL Server Replication be a goo...more >>

hi, we are doing mergereplication of 6 database in a same server. we updated nearly 2lacs record in 2 databases. But in only database only we got the message no data need to be merged in another one its still showing connecting to subscriber. please give me a solution as early as poss...more >>

I am trying to use a remote distributor and I think my settings are wrong for RPC and mapping. How should these be mapped so that the publisher can see the SQL Server Agent on the distributor? --Kristy ...more >>

Greetings: We have set up a test scenario in Sql Server 2000 using merge replication with: A primary synchronization server (Publisher A) An alternate synchronization partner (Publisher B) Two subscribers to both publishers (Subscriber Y and Subscriber Z) After some initial difficulties...more >>

Hi, the Merge-Agent stops with the following error: The merge process couldn't recall the information for the table 'xxx' What is the reasen for the problem ? What can I do ? Best regards Axel Lanser...more >>

I was looking into replication, but I didnt want to get into having to rebuild replication everytime we updated our Database. I really just need to setup a read only mirror. I was looking into LS (Log Shipping) and that doesnt seem like it would work that great. Since I need our mirror able...more >>

Ok I'm going to post this again in another way. Here's what I have. 2 databases p3e_master and winship. winship has a merge publication that I use with sqlserverce for pocketpc users. That works fine. p3e_master has a transactional updateable publication that includes 3 tables. Those...more >>

I'm getting an application error message at the subscriber = 'invalid object tsvw'. May I just copy all the views from the publisher to the subscriber? ...more >>

Simply says that there are no transactions available. But when I go to my production app and add some things it still says the same thing. --K ...more >>

I wish to implement cascading deletes with a SQL-Server merge application. I have google'd this and have reached the conclusion this is possible. My question is how to implement this... I've checked the 'cascade delete for related records' option in the EM ERD. But i know from searching...more >>

I am looking at some data in the distribution.MSsubscriptions table and the subscriber_db field has a value of of virtual. I have several of this entries all with subscriber_id's of -1 and -2. Does anyone know where this comes from. Bert ...more >>

Hello, I wrote a desktop application with a SQL Server 2000 database and a mobile application for PocketPc with a SQL Server CE Database and I realized a replication mechanism that when the user presses a button on the PocketPc application the data will be synchronized via WLAN and the upda...more >>

Is there a way to specify more than one field for the Additive Resolver argument? I have multiple fields in a table that I would like to be summed from multiple subscriber updates....more >>

Hi, I have 6 pushmergesubscriptions A,B,C,D,E,F I wan't to start the merge-agent A at 8.00 PM, B after ending of A, C after ending of B, D after ending of C, E after ending of D and F after ending of E. How can I start the next merge-agent after finishing the the last merge-agent ? Be...more >>

Hi, how can I start the snapshot-agent in a sql-script ? Best regards Axel Lanser...more >>

Hi, after restoring a publisher database, the definitions for the publisher woudn't be restored completly. When I try to delete the rstored publisher, I get the message Error 20026: The publication XXX does not exist. What can I do to delete the publisher ? Best regards Axel Lanser...more >>

Either through EM or using sp_dropsubscription. Whole system locks up. I've even tried to drop it on a per article basis. First few table/articles went fine, but when went to drop an article for a very large table, whole system locked up again. --Thanks, Kristy ...more >>

How do i register a server in EM through a VPN? -- Wack ---- This message will self destruct. ...more >>

The process could not read file 'd:\sql_data\MSSQL\ReplData\unc\...\20050324084140\snapshot.pre' due to OS error 3. What is going on? -- Wack ---- This message will self destruct. ...more >>

I have a transactional replication with one publisher and one subscriber. This is working fine. Now my developers need to make changes to the production database. They would like to change columns, add new indexes, etc. What is the bet way to do this without much down time? -- George Gopie...more >>

My bookmark http://www.replicationanswers.com/default.htm and the page is not available for 2 day???...more >>

Hello, I have transactional replication in place with @ 450 articles in the main publication. I need to modify the primary key to include an additional field. How can I do this best? Thanks. ~Lb ...more >>

How does one figure out what type of hardware is minimal and what type of hardware is optimal for each server involved in replication? --K ...more >>

I recently changed my snapshot agent schedule to run 1x each night. In the Job History (SQL Server Agent), it shows to run as scheduled. However, when I look at the Agent History, it is recording session activity every hour. What is going on here? Thanks, Buddy...more >>

Hi all, We have a 8 Gig database that we would like to replicate and is growing everyday as transactions are constantly coming in. After setting up the replication we need to send the replicated server to another area of the country. It will take a week to get there. The question is once th...more >>

as subject. Cheers nick...more >>

Hi, I'm running SQL Server 2000 EE SP3 on Windows Server 2003. I have multiple named pull subscribers to a Transactional replication model. I have written a script that adds and drops fields from several tables using sp_repladdcolumn and sp_repldropcolumn. I also have some commands in ...more >>

Hello, I setup replication between 2 computers, but it keeps crashing because (I think) the database table names include spaces. I have the option to go through each individual replication stored procedure (3 per table) and edit them adding [] to each....but I'm replicating more than 100 tabl...more >>

I have finally got all the bugs worked out of my TransRep publisher -> Distributor/Subscriber set up when I got hit with a new question that I can't answer. I've been asked to alias a few of the columns so that in the replicated DB they show up with a different header than the columns in the ...more >>

Hi, how can I make it work the following procedure: http://support.microsoft.com/default.aspx?scid=kb;en-us;319646 in a Web Service? Namely, the previous procedure should become a web service... I have already tried to create a web service and copy almost all the code... but after having ref...more >>

I want to remove a table after merge replication, and i want to change the identity range for replication How can I modify the table or remove it from the Publication so that it can be modified? Regards Srinivasan K ...more >>

Hi, please help. I am trying to set up a Pull subscription using FTP. I am getting this error in my distributor agent: 200 Type set to I. 200 PORT command successful. 550 NTS60-02_xxx_xxx\20050322100131\trnh_1.sch: The system cannot find the path specified. 550 NTS60-02_xxx_xxx\200503...more >>

Ive read BOL and am having a really hard time getting my head into this topic. I have two Publishers replicating the same table both pointing to the same Subscriber for Reporting purposes. They both have Identity columns. (NOT USING the "Not for Repl" option.) One has the range on 1 -100 and the ...more >>

We have a 100+ GB database as our production db. We need to replicate to a subscriber across a wan to have absolute minimal latency. Originally this was configured to be a push subscription with the publisher acting as the distributer. The distribution agent ran on the publisher as well. We...more >>

Say I have a stored proc SP1 that updates a table T1 . So when I setup my publication and intend to replicate the execution of the stored proc, do I need to also include the underlying table T1. I am thinking that if i do, the subscribing table T1 might have data duplicated right ..one by the e...more >>

I've been doing some reading about log shipping and was wondering if someone could just confirm what it is I think I understand: If you use the Log Shipping Wizard in Enterprise Manager, once you restore the database and the subsequent logs, your database will still be READ ONLY. Now, if I ...more >>

Dear All, Can anyone point me to a resource for the best way to disable transactional replication for one database where there are multiple databases on a server being replicated. Thanks Peter...more >>

Please Help me with this problem , I am working with merge replication , i have got publication for local network and i want to chage it to publish the articles on internet without creating new publication. Please Reply Thanks Abulla Fatiya ...more >>