We have two servers A and B, on Saturday and Sunday data will be entered on server B, and between Monday and Friday users will enter data on server A. We need to transfer data in Friday from server A to B, and in Monday from B to A, using 56k, modem connection. There is possibility that someon...more >>

Hi, I don't want one table to replicate out of 100 tables. Actually when tables are replicating one table is having image column and is causing issues and replicatoin is failing. I want to avoid this table to go for replication. -- Sanjay...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

i am using SQL2000 and have setup transactional replication on a database. The publisher and distributor have been created and im pushing the replication to our secondary server. The issue i am having is the following....the database appears to replicating correctly....but the data on the su...more >>

Hi all, ok i have a slight issue ive got a merge replication setup, and its all bin running really well, until the other day i copyied some data into a table using the DTS wizard, and o nice, it didnt get replicated accross. Hence making the table fail its row count and data validation, So ...more >>

Recently rebuilt Windows 2003 OS, SQL Server 2000 sp3, 3 publishers of various shapes and sizes. I am almost certain that I re-created the distribution database using the file properties before everything was moved to the new OS. I ended up having to drop and recreate replication because I did...more >>

Is there a way to avoid resetting connections to the db on the secondary server, while using log shipping? I appreciate any pointers in this regard. Thanks, Subra ...more >>

Hi I am running a couple of sql 2000 SP3a servers with merge and snapshot replication. One server acting as publisher and distributor and the rest subscribers. On one of the server I have got the error below and have tried most of the suggestions by msdn. This server has not crashed ever befor...more >>

I see from other posts that sp_addscriptexec is recommended for updating/creating indexes. It isn't clear to me if I can use Enterprise Manager to go into the table on the publisher and add additional indexes on a table and then have the added indexes automatically populate to the subscribers. ...more >>

Hi all, i've a question/problem: we are using several sql server at several locations. Now we want to replicate the data from all servers to "one central server". After long time of searching the internet an reading different aricles i decided to use the transactional replication for my p...more >>

I am trying to set up Multiple Publications into single subscriber database using merger replication, I have done so in the past using Transactional using Row filters and making sure that not both of them drop the tables on reinitialization. However i'm now tring to do this with merge for anothe...more >>

I have a merge replication that has nine publications. I want to script the steps to run publications 2 thru 9 and applied them using Query Analyzer to publication 1. My intent is to run the pubs from the steps on pub 1. Is there a way to accomplish this? I setup replication between publisher...more >>

Hi Group, I have an SQL Server with a database called support for which I have setup a merge replication subscription called "support". On my laptop, I have a support program using MSDE locally to access an exact copy of the data as the main SQL server has. Whenenver I try to synchronis...more >>

Hello All, Here is my situation: I have a core database that is used to define the schema of a client-owned database for use with some software. As the software evolves and changes so too will the schema of the core database. Ideally these changes should be propogated down to the clien...more >>

Hi! I have several publications that need to be replicated to into a single subscriber. Each publication comes from a different publisher db. How can I best accomplish this task? I am currently using snapshot replication on the publishers. Thanks!...more >>

Greetings from Serbia! Does anyone knows how to rollback data on subscriber when we loose connection in middle of merge replication between two servers? Thank you in advance, Stanko Milosev www.milosev.co.yu ...more >>

I am having a problem with one SQL Server. I found a post dated 8/2002 that describes my problem (see below) I have Transactional Replication setup between two servers (both running 2K server and SQL 2K). I'm using the local server with a pull subscription from the remote server. I'm having...more >>

Hi, the Merge-Agent stops with this error: Columname 'rowguidcol' is invalid executing this command {call sp_MSmakearticleprocs (?, ?)} What is the reason for the error ? How can I solve the problem ? Regards Leandro ...more >>

Hello Everyone, I am running SQL2K with sp3, continuous merge replication, only one subscriber. My current setting for Subscription expiration is the default of 7, I have just recently changed this from the default of 14 days, as our Subscriber is basically always available. I am still t...more >>

A general question on sp_addarticle: I read in a post here that the best way to genreate the value for schema_option is to choose your options graphically and let EM generate the value.... That doesn't seem to make any sense to me...if you're using EM to add the article, it doesn't gener...more >>

Hey guys. Really stuck in a jam on this one. SQL subscriber is behind a firewall, so FTP snapshots don't work. From behind the firewall you can only connect to an external FTP server and transfer data via FTP Passive mode. I can't find anywhere a setting for SQL 2000 to use passive mode....more >>

Hi, We use push transactional replication successfully and are about to bring a few remote on-sites into the fold. The connection speed will be low - in the 64k/128k range. As I understand it "Not for replication" means that a trigger on the subcriber will not fire if the update is generated ...more >>

Hi, I have my Stored Procedures set for replication. If the stored procedure on the publication is new it gets replicated but after that any changes made in the stored procedure are not replicated. Is it meant to be like this? If not, what am I missing? Thanks Vivek ...more >>

Dear All, After marked re-initialize an existing publication, a new snapshot has been generated and applied to the subsciber, after that, there is an error on Distributor agent saying that can't apply command as duplicate key error. I have checked those insert commands and those records are a...more >>

Scenario: Multiple customers running identical databases in a hosted enviroment. Need to do point-in-time ETL of select tables into a single consolidated database for read only reporting. Point-in-time does not have to be the same for each source database. A data transformation must take pla...more >>

For merge replication I have only a few tables where the primary key spans two columns. For the rest of the tables the primary key is one column and is a uniqueidentifier. For the fre tables where it spans two columns, I have to add an additional uniqueidentifier column and mark it as the ...more >>

I have successfully implemented transactional replication on our web server to a backup server. The process is working wonderfully. Now we are documenting the steps that need to happen to bring the database back to Server A in case Server A were to fail. Our IP management system would autom...more >>

I'm getting an odd behavior in my replication setup. Here is the current scenario: - I have one publisher that is also acting as a distributor. - There are tow SQL Servers who are subscribing to this publication. - There's no filitering or anything special - just straight tranasctional repl...more >>

Hello all. Me again. I'm finding some of these replication errors very hard to track down. With your great guidance I'm working on replicating via the internet. I think I know what has to be done now, but when configuring the publisher to create ftp snapshots, the snapshot agent is throwing...more >>

I set up a test SQL server that I want to be exactly like the live server. The test server is only available over the internet connected via TCP with no network sharing or anything like that. What is the best way to copy the data [all databases, tables & stored procedures] from my live server...more >>

Hello All, I admit I am new to the replication spectrum, all my experience is basically reading. If you know of a book or site that has all the details please let me know. These scenarios occur in the application that I am about to develop Scenario #1 Client X wants specific data be dow...more >>

Hello All, I admit I am new to the replication spectrum, all my experience is basically reading. If you know of a book or site that has all the details please let me know. These scenarios occur in the application that I am about to develop Scenario #1 Client X wants specific data be dow...more >>

Dear Sir/Madam, I am replicating 5 tables from Server A to Server B. On my first setting, I included those 5 tables on a single publisher. After that, I recognize when a table schema changes, I needed to drop and re-create the publishication, means all 5 tables needed to re-synchronize again,...more >>

Hi, the Merge-Agent stops with errornumber -2147199481 ? When you need a logfile, I can send you one. What is the reasen for the error ? How can I solve the problem ? Best regards Axel Lanser...more >>

Hello, We have 2 sql servers - A and B. A contains one database - A1. It is the web store - internet users can modify tables /new users, new sales orders etc/. B is local server. Server B contains 2 databases: B1 - mirror of the A1 B2 - database for erp information system. Local users mod...more >>

Does anybody have any commnets on a backup strategy with Merge replicated databases. What happens when you restore a subscription database will changes previosly propagated to it be reapplied. Is there any point doing transaction log backups, what will happen if the publisher is restored...more >>

Hi all Gurus Will I have any problem for stopping the log reader and then restarting it when the system clears up? Thanks ...more >>

We have one publication having all the tables, then another publication for stored procs, yet another for views and one for indexed views. And all set up for transactional replication. I understand the need for the tables portion. Right now, the stored procs, views and indexed views are just to ...more >>

Hello, In a project I work on, there's a server and many clients connected to it. They go offline sometimes and before they do that they request several items from the server which are then "downloaded" to the client computer - they basically consist of several rows in related tables (plus se...more >>

We do nightly processing for our warehouse data on Server A and we replicate the data after all the processing to Server B. What is the fastest way to push this data across ? Right now it seems like it takes more than an hour to push all the changes across.i.e an hour latency. We are using tra...more >>

Hi, Had merge replication set up between two servers. with push subscription. For various reasons the replication stopped running for a few days and now we have different data at both sites. Does anybody have a series of steps to get this back up and running other than the following. ...more >>

Say I have 3 tables A,B and C in a single publication. I am doing transactional replication from Server A to Server B. Say i perform a lot of data manipularion (inserts/deletes/updates) on A and B back and forth. After all this manipulation is complete, I then add a record in table C. What ...more >>

hi all, Can I filter rows dynamically in merge replication when the program is running? It seems that's impossible? Thanks, KNC ...more >>

How does the historyverboselevel and transactionsperhistory correlate ? If i change the historyverbose level to 3 for the distribution agent profile, do i also need to increase the transactionsperhistory ? I dont follow what the transactionperhistory is. Also the agents can log to output file ...more >>

Hi, I'm trying setup a package to replicate a database table into a another database's table. I thought a Data Driven Query Task would work. I got as far as making the two connections and setting up the Data Driven Query's source SELECT (with stored procedure I created in the source da...more >>

Strange issue (aren't they all). On my VB.Net app, I use merge replication. Everything appears correct with synchronization and data flows in both directions. However, I have noticed that on the SQLCE tables where I do multiple Inserts, I'm now getting an error after the second synchronization...more >>

Has anyone seen this error before? It ulimately causes replication to fail. The error message is: Error at parameter 93 during datastream processing of parameterized command. -- Keino Jason SQL DBA/Developer ...more >>

Running SQL 2000 (SP3) & Win 2000 My snapshot agent in EM shows, 'Running', then I get an error 'The agent is suspect. No response within last 10 minutes.' Also, the log reader shows 'Running' but no transactions are getting replicated. HELP!!! TIA, Larry... ...more >>

Hey there, I've done replication with CE based devices but this is my first time working on server to server replication. Here's my scenario. I have 2 servers. -------------------- Publication Server -------------------- Firewall allowing port 1433 SQL 2000 -------------------- Subscri...more >>

Does anyone know what the source_type_id values relate to. I have errors with values of 5,4 and one. I thought that they signified agent types but agent types are 1 Snapshot Agent 2 Log Reader Agent 3 Distribution Agent 4 Merge Agent I am not using merge and there is no agent type of 5...more >>

Hi All, Please advised how to using query update table, but I don't want to clear table before updating....more >>

We have a replica process full merge with many pull subscribers. We have activated a new push subscription for a new subscriber, publicator of another process of replica. We have some problems do this, and so we have to delete the work we did by Enterprise Manager. Now we can't create the sub...more >>

I understand that MS SQL Server does not support multi-master replication. Has anyone tried to implement multi-master replication under SQL Server 2000? Does SQl Server 2005 support it? Thanks rad...more >>