Can i use Group by in the row filter when i doing merge replication? Cheers nick

Nick

01-31-2005 10:50 PM
Hilary Cotter

Under "Replication Monitor", "Publishers", "<SERVERNAME>". There are lists of publication. Whenever a new user synchronizes with a publication, there...

Vaquar

01-31-2005 04:31 PM
Vaquar

Hi, I am trying to detach a database to move to another locaion on the same machine The database has replication. I get the following...

Paul k

01-31-2005 02:01 PM
Paul k

We are using merge replicaiton and will do A publisher to B, C and D E publisher to B The data of A and E are same. B, C and D are subscribers. ...

ping

01-31-2005 11:27 AM
Ping

Sync data between OLTP data tables and OLAP fact tables. I have my data in several data tables, I had built a view to aggregate the data from...

Joel Leong

01-31-2005 11:16 AM
Hilary Cotter

When I create a publishe and distributor and I set the snapshot location to a network accessible drive for the subscribers to be able to access. I...

Shane Lim

01-31-2005 10:51 AM
Paul Ibison

What port is used for merge replication? The same as clients uses to connect to SQL Server ? -- Best Regards Wojciech Znaniecki

Wojtek Z

01-31-2005 07:53 AM
Paul Ibison

updating publicatgion DB base on subscription DB changes, is that possible to do? and how can we make sure the orders? cheers

Nick

01-30-2005 08:51 PM
Nick

Hi, One of our subscriber server is full due to transaction log too large. The replication was failed without no space for the transaction log. My...

Ping

01-30-2005 01:31 PM
ping

Type Replication: Merge Type Suscriber: Pull 1 Server Publication 5 server Suscriber's after a reinicialition on one Server suscriber, all data...

Manuel

01-28-2005 05:44 PM
Paul Ibison

CREATE TABLE ( IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , NOT NULL , (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , (3) COLLATE...

Manuel

01-28-2005 03:33 PM
Manuel

I am trying to separate two applications sharing the same database and a few tables(like t_employee) in a phased approach. How can I best setup a...

David Walpole via SQLMonster.com

01-28-2005 02:09 PM
Hilary Cotter

I want to update SQL Server version from 7.0 to 2000 but my installation is replicated in another 7.0 SQL Server instance. Can I update only the...

Enzo Giurleo

01-28-2005 09:29 AM
Hilary Cotter

I have a database working with Merge replication, there could possibly be a audit database associated with this replicated database. After talking...

Pauly C

01-28-2005 09:27 AM
Pauly C

Is it possible to set up replication from Single-Filegroup to a Multi-Filegroup? Thanks,

Joe K.

01-28-2005 08:45 AM
Hilary Cotter

Hi I have a SQl databse on a web hosting server, and I have the databse locally on one machine, I'd like to know if I can synchronize the data...

Hermione

01-28-2005 08:33 AM
Hilary Cotter

Hello, For political reasons, I need to havec datas stored both on a SQL Server 2000 and a Sybase ASE v12. If data changes in SQL, it must be...

Steve B.

01-28-2005 08:30 AM
Hilary Cotter

Hi All, I have Sql-Sever 2k SP2 and Win2K SP4 Advanced server. Topology : Republisher Publication Type : Merge with dynamic Filtering. Everything...

Raydl

01-28-2005 06:39 AM
Raydl

"Karim Virani" wrote: Actually I just tried this, and it was no problem. I did it in the following order: 1)I created a new database in Enterprise...

Daniel

01-28-2005 04:57 AM
Daniel

did Anyone implement Merge replication over internet? and wht were the results, i need a detailed procedure of implementing replication over...

Daniyal Khan via SQLMonster.com

01-28-2005 04:18 AM
Paul Ibison

Hi All, Setting up transaction based replication or merge replication bi-directionally forces me to use a unique identifier. I want to...

Russell J Morgan

01-28-2005 03:19 AM
Paul Ibison

Hi, I have 2 different subscribers for the replicated database. What I want is that do is to provide subscribers access to different tables i.e. if...

Vivek Sharma

01-28-2005 03:15 AM
Paul Ibison

Hi All, We know that, "NOT FOR REPLICATION" option makes it possible for replication agents ,let's say, to insert rows without being constrained by...

Nury SWORD

01-27-2005 03:57 PM
Nury

Greetings, I have developed custom replication software that I have been running in house for 2 years now. During replication operations I have...

Mario T. Lanza

01-27-2005 03:54 PM
Nury

OK - I've put them on the downloads section. I can't give you the precise link, other that request that you browse to www.replicationanswers.com, as...

Stefan Gevaert

01-27-2005 03:35 PM
Paul Ibison

Hi there, we are using merge replication with anonymous pull subscribtion, wrutten in active X control. Every things is working fine but all of...

itimilsina@savannaenergy.com

01-27-2005 02:46 PM
itimilsina@savannaenergy.com

Hi, We are using merge replication to replicate data from server A to server B, C and D every day. Server A is a publisher, server B, C and D are...

Ping

01-27-2005 01:49 PM
Ping

I have a server work as publisher and distributor for a database and another remote server work as subscriber. The remote server downed and...

Clarin

01-27-2005 12:42 PM
combfilter

Does that sound right? Now what is happening is that all the transactions that were waiting behind that snapshot are so far behind I am afraid...

combfilter

01-27-2005 12:39 PM
combfilter

I want to formulate a comprehensive disaster recovery procedure for my system. I am running two SQL 2000 servers with replication. I find that some...

gemel

01-27-2005 11:29 AM
Paul Ibison

I know you can have SQL Server email you when a replication agent fails, but we had the following situation: schema change on table broke...

AW

01-27-2005 09:46 AM
Paul Ibison

Hi Guys, I am having a slight issue with adding a push subscription to a merge publication. I have enabled replication and created the publication...

Russell

01-27-2005 09:33 AM
Russell

hi there: i got a big problem here. i call serval store procedures from c# to drop a republication. the code likes following use GO -- Dropping...

victor

01-27-2005 03:45 AM
Paul Ibison

I followed the directions from a previous post by adding a 4th step and changing the 3rd step to continue with success. When I applied the...

Pauly C

01-27-2005 03:34 AM
Paul Ibison

Hi We are considering an access front end app with back end tables on sql server in our office. Is there a way to have a copy this app on a...

John

01-26-2005 06:06 PM
John

I'm doing to much testing with the sp_addmergearticle but only with this steps I can add the article 1. I'm droping the registers from the table...

David Barquero

01-26-2005 04:41 PM
David Barquero

Hi, Is there a way that I can set up an email notification that can notify me whenever there is a conflict during replication? Thanks

Vivek Sharma

01-26-2005 03:35 PM
Paul Ibison

Hi , I recreated all the subscriptions and now I am getting error for one of the tables The merge process could not retrieve identity range...

Vivek Sharma

01-26-2005 03:14 PM
Vivek Sharma

Hi, I am trying to do Merge Replication between SQL 2005 and SQL Mobile Edition. I did set up Publication and Distribution successfully using SQL...

Niben

01-26-2005 02:03 PM
Niben

Hi, I do not recall if snapshot replication allows no data replication. If there is a dummy filer that need to be placed on each objects I guess...

Christine C

01-26-2005 01:55 PM
Christine C

I set up a transactional push replication and basically would like to use the subscriber as the archived historical database server. Once the...

Paul Lennon

01-26-2005 12:42 PM
Paul Lennon

I have a current application written in Access 97 (front and back end) using replication, using an interface i have written to...

Eric

01-26-2005 11:20 AM
Eric

I have a merge replication environment with 1 publisher/distributor in the same machine and 3 subscribers with a lot of data to merge. The link...

toryi

01-26-2005 11:00 AM
toryi

Hi, I set up transactional replication with pull subscription. Initially everything works fine including getting the initial snapshot. But when...

Eric

01-26-2005 10:19 AM
Eric

Hi I want the last change remain, when I have a conflict between subscriber and publisher.it means that I want the the earlier always win (the data...

Tajik

01-26-2005 10:05 AM
Paul Ibison

How is working Microsoft Replication Conflict Viewer? Clicking on "Keep winning change" only delete rows in conflict tables? Clicking on "Resolve...

Olivier Monney

01-26-2005 09:14 AM
Olivier Monney

I am updating rows in a particular table in my sql ce 2.0 database. After I synchronize with the publisher, the updates are gone, as if I had...

Thirsh

01-26-2005 09:04 AM
Hilary Cotter

Hello. I have problems in merge replication from SQL 2000 (dev.edition) to SQL 2005 Express. I did all things mentioned in BOL (for Express) to setup...

MaxX_RUS

01-26-2005 08:57 AM
Hilary Cotter

after I replicated two project server database in two sql server, I don`t add new user or modify old user in project server,Why????????? and another...

Bita Joghataie via SQLMonster.com

01-26-2005 08:51 AM
Hilary Cotter

Hi There, I created a merge artcile and forgot to set auto_identity_range as tru and now I want to set it. Can any one suggest how can I achieve...

Vivek Sharma

01-26-2005 03:28 AM
Paul Ibison