I just ran into an odd error, and I'm trying to figure out what happened. I replicate a table "rules", from ServerA to ServerB. ...

M Bourgon

07-26-2009 01:11 PM
Paul Ibison

Using SQL Server 2008 Situation: DB 'Server1' with merge replication (done with wizard) - @pub_identity_range = 10000 and @identity_range =...

João Passos

07-26-2009 01:05 PM
Paul Ibison

Recently, my AD username was changed. Where ever I add a subscription, SQL grabs my OLD username. Being this username is no longer valid in AD, the...

LPR-3rd

07-24-2009 12:24 PM
Russell Fields

Hi I want to republish data in sql server. Scenario is like this. SERVER A SERVER B SERVER C Publisher --> ...

DishanF

07-23-2009 08:41 AM
João Passos

Hi All, I have recently setup publication over wan. The tokens doesnot seems to be getting through. Does any body have faced this issue. Thanks in...

siddu

07-22-2009 10:27 AM
Paul Ibison

I haven't been able to resolve the timeout issues when trying to initialize the 100Gb database I've referred to in other posts. I'm trying, instead,...

Don

07-21-2009 02:17 PM
Don

All hail: I'm trying to initialize a 100+Gb database via web synchronization. I have -InternetTimeout set to 9000 seconds (150 mins) and...

Don

07-20-2009 09:49 AM
Don

Hi, i would like to monitor a subscription to a merge publication at the Publisher using RMO Programming. There is a tutorial to this monitoring at...

João Passos

07-20-2009 09:49 AM
João Passos

Can I restore a database that is currently a subscriber to a publisher? Meaning, that if my publisher goes down, I would like to restore the last...

Erik G

07-19-2009 11:46 AM
Paul Ibison

Hi Experts, I am new in this area and no nothing abt replication so.. i need your advise pls. we need to setup replication between 2 server. Our...

vinu

07-19-2009 11:43 AM
Paul Ibison

Hi all, I'm talking about a transactional replication, let's say that I've this table that I want to replicate over the subscribers: ID ...

Andrea Caldarone

07-19-2009 11:22 AM
Paul Ibison

Hi All, I have several publications (transactional replication). For some of the publications I have observed that the...

siddu

07-19-2009 09:20 AM
siddu

Are there any recommendations for enabling row versioning with replication? Fore example, in our environment we use one database for...

Mark Price

07-17-2009 08:35 AM
Jelle J.

I am trying to replicate from SQL Server 2005 SP3 to SQL Server 2005 Express Edition SP3. I've setup a publication without problems. I can start a...

Matt_Beechey

07-17-2009 04:27 AM
Matt_Beechey

Today I set up a replication with one subscriber. It took some time to apply the snapshot to subscriber now I have confirmed the replication is in...

Shiju Samuel

07-17-2009 01:29 AM
Shiju Samuel

hello i have standalone sql 2008 entreprise edition with default instance sqldef and second instance inst2 in the same vista computer. i'am trying to...

test windows

07-16-2009 08:43 AM
Don

Hi all, My configuration is: SQL 2005 SP3 ( publisher and 3 subscribers ) Pull transactional subscriber (compress snapshot with alternate...

Eyal Schapira

07-15-2009 12:55 AM
Eyal Schapira

Hi friends, I am facing a problem, actually we have three servers, let’s say server A, server B and Server C . All the three servers have same...

Manpreet Singh

07-14-2009 05:12 PM
Paul Ibison

Using merge replication I regularly experience an error similar to the following one when rows are inserted on the subscriber side: (translated from...

Thomas

07-14-2009 04:32 AM
Thomas

Sorry for this question but I'm having trouble finding the answer definitavely in the documentation. I have a publication and a pull subscription...

seanD

07-13-2009 06:32 PM
Chris

I have a requirement as such. A developer wants to replicate a table and be able to: 1. execute a distribution to pull records via pull...

seanD

07-13-2009 06:26 PM
Chris

All hail: The question up front: Is there a way to change the folder to which merge replication web synchronization caches snapshot files so that...

Don

07-13-2009 10:55 AM
Don

I received the error Replication-Replication Distribution Subsystem: agent R00S-SQLA- PO_SYSTEM-PO to Store 05-ROUSE05SERVERB-2199 failed. The row...

LPR-3rd

07-13-2009 10:34 AM
Paul Ibison

I am working on a proposal for a contract I have where there are two production SQL Servers that are going to be load balanced by the application (no...

Michael MacGregor

07-10-2009 07:23 AM
Michael MacGregor

Can anyone recommend some good books on Replication for SQL 2000/2005/2008? TIA Michael MacGregor Database Architect

Michael MacGregor

07-10-2009 03:25 AM
Rubén Garrigós

HI, rightnow we are using oledb provider for replication(oracle to sqlserver 2005) i heard ATTUNITY provider which is new to microsoft is doing...

pardhiveswar via SQLMonster.com

07-08-2009 04:38 PM
pardhiveswar via SQLMonster.com

We recently setup merge replication on 2008 SQL Server and created 2 subscriptions for laptops. One works fine but the 2nd one does not show...

David C

07-08-2009 03:06 PM
David C

We already have a SQL Server 2000 (SP3) in transactional replication having SQL 2000 pull subscribers. We are planning to add one SQL Server 2005...

Fraz

07-08-2009 01:59 PM
Fraz

I have a simple publication of a few tables in a database that has been running for a few years. Over the long weekend, the connection was out...

Ben Walling

07-08-2009 07:34 AM
Paul Ibison

We already have a SQL Server 2000 (SP3) in transactional replication having SQL 2000 pull subscribers. We are planning to add one SQL Server 2005...

Fraz

07-07-2009 03:19 PM
Fraz

Hi NG, I am new to replication and my posting in the german-speaking newsgroup had no success. My problem: For testing is established a publication...

Nicolas Nickisch

07-06-2009 10:54 AM
Hilary Cotter

How do I get notification when there is a problem with replication? Do I use notification services? TIA - Jeff.

Mr.Magic

07-01-2009 02:25 PM
Linchi Shea

How do I clean out the distribution database? I have one publisher with one subscriber and the database is 480MB and is full. But it looks like...

Mr.Magic

06-30-2009 03:16 AM
Paul Ibison

Is there any way to see what the SQL is that replication is trying to run? I'm getting a String or Binary data would be truncated but I don't...

Mr.Magic

06-29-2009 01:55 PM
Mr.Magic

Hello: I have access to an ORACLE 10 R2 database. I also have SQL2008 SP1 I would like to set up SQL 2008 to subsribe to an ORACLE...

GADOI

06-29-2009 07:55 AM
Jelle

We would like to know what the requirements and settings are to get all data (e.g. varchar(), nvarchar(), text and ntext) replicated using...

Hugo

06-29-2009 03:07 AM
Hugo

Good spot Hilary - thought it was MSmerge_history but for MSmerge_genhistory this is metadata controlled by the "retention" setting instead. Cetel -...

Cetel Sistemas

06-27-2009 06:11 AM
Paul Ibison

I want to maintain a data warehouse using snapshot replication. Or I think I do. What I need to do is everyday I need to look at the sources...

Heath

06-26-2009 03:29 AM
Paul Ibison

I BOUGHT A COMPUTER FROM EBAY, AND IT HAD WINDOWS XP ON IT. I HAD SOME PROBLEMS WITH IT, SO, LIKE AN IDIOT, I DID A SYSTEM RESTORE. I TOOK IT BACK...

MARY RINEARSON

06-25-2009 01:49 PM
MARY RINEARSON

About six months ago, some of our subscribers began failing with various errors like: "The change for the row with article nickname , rowguidcol...

KJVT

06-25-2009 09:32 AM
Charles Wang [MSFT]

We just moved our SQL 2005 database to 2008 and setup merge replication. We installed SQL Express 2008 on our laptops and created subscriptions from...

David C

06-24-2009 07:49 AM
David C

SQL Server 2000. Replication was installed and then removed. After removal of replication the syncobj views are still present in the Database that...

B.Edwards

06-22-2009 09:46 AM
Paul Ibison

:) Happy Friday! If we setup replication between a production and test database server, and the test database server's date is routinely changed...

Kevin Schultz

06-22-2009 09:33 AM
schultkl

Can you post up contents of attachment - I'm using a browser so can't see attachments. Cheers, Paul Ibison

Paul Ibison

06-19-2009 12:45 PM
Hilary Cotter

:) Happy Friday! If we setup replication between a production and test database server, and the test database server's date is routinely changed...

schultkl

06-19-2009 09:56 AM
schultkl

We will be moving our SQL 2005 database (with Merge replication to laptops) to SQL 2008. Is there a process to do both that is reliable? Or is...

David C

06-18-2009 11:07 PM
Brian

I have tried both SQL logins with sa permissions and then windows logins also with sa permissions to both servers as well and I still get this...

John F.

06-18-2009 04:28 PM
zx9hippo

Hi , do we need to reboot the servers involved in replication in sequence like distributor first then publisher and then subscribers,what are the...

sacgar

06-18-2009 03:30 AM
Paul Ibison

I would like to apply MS SQL 2005 SP3 into a transaction replication environment. Do I need to stop replication before apply SP3 at publish...

KT Wang

06-18-2009 03:28 AM
Paul Ibison

Hello! My transactional publication normally runs fine, but every once in a while the swedish characters for certain columns are messed up in the...

David

06-17-2009 01:33 AM
David