I have this error coming up 'The process could not execute 'sp_replcmds' on 'VDB1' which always seems to accompany 'Logreader failed to...

Chuck Lathrope

05-04-2007 04:08 PM
Chuck Lathrope

Hi, I have a requirement to replicate a database for reporting purposes. I would like the publisher and subscriber to reside in the same instance...

tommcf

05-04-2007 03:50 PM
Paul Ibison

I'm in the middle of setting up a non-updating transactional replication from SQL Server 2000 SP3 (can't put SP4 on as the main application we...

Daniel Crichton

05-03-2007 09:07 AM
Daniel Crichton

Dear all, I have a web application that uses sql2005 database. And a local windows application that uses exactly same sql2005 database structure. I...

msnews.microsoft.com

05-03-2007 05:36 AM
Paul Ibison

Help. I am having a hard time getting the snapshot agent to run when I create a distrubution/publication and then a subscription. I followed the...

SAL

05-03-2007 03:21 AM
Paul Ibison

I'm having a problem trying to deliver a snapshot. I'm using transactional replication with a pull subscription. I'm publishing the snapshot to FTP....

wtf_is_this

05-02-2007 11:52 PM
wtf_is_this

Hi, I 've a sql server 2005 standard edition SP2 x64, configure with transational replication. I've enabled alert 14150 "Replication:...

Alvaro Mosquera

05-02-2007 06:07 PM
sqlmaniac

Hi, Our production database runs on SQL Server 2005 (SP1) and I want to implement currently no-partition to partition table. Does anyone can...

Chen

05-02-2007 05:58 PM
SyNEttech

Hi currently we are using server1 (publisher) second server distributor and other 5 servers as subscribers with service pack 3.we are planning to...

pardhiveswar via SQLMonster.com

05-02-2007 04:14 PM
Paul Ibison

I am having issue where the data are not getting displayed on subscriber but are on publisher. so if i run query in query analyzer on publisher i see...

myrights99@gmail.com

05-02-2007 04:09 PM
Paul Ibison

I'm getting some records coming up in the conflict viewer which havn't been inserted because there is a "Violation of the Unique key constraint". ...

Spike

05-01-2007 07:41 PM
Crash

On SQL Server 2005 SP2 we got this "new feature" which I am probaly aware of why you do need the update statistics but what I can't tell is WHY you...

isyourfriend@gmail.com

05-01-2007 05:24 PM
Raymond Mak [MSFT]

I have a database with merge replication setup in SQL 2000 and currently have active subscriptions. I have 2 applications that use this database. ...

Guy Thornton

05-01-2007 08:33 AM
Guy Thornton

Where to start troubleshooting the failure of schema to replicate from one server to the next.? -- Sandy Wood Orange County District Attorney

Sandy Wood

05-01-2007 03:24 AM
Paul Ibison

Hi Guys, I have question regarding replication. I have 30000 rows data that need to replicate from server A to Server B. It might last 2 hours to...

Iter

05-01-2007 03:22 AM
Paul Ibison

how to you measure Latency in pull or push sub/publist architecture? Do you have a set of scripts which use to monitor and setup the replication...

soalvajavab1@yahoo.com

05-01-2007 03:21 AM
Paul Ibison

We have an application that uses SQL Server 2000 merge replication with dynamic snapshots. At one of our clients, the dynamic snapshot jobs are set...

kthl

05-01-2007 02:05 AM
kthl

Does anyone know why the "remote proc tran" sp_configure option prevents you from creating a publication in SQL Server 2000? I'm just finding forums...

BATMAN

04-30-2007 10:31 PM
BATMAN

I need to bring in data from mySQL to SQL server (2005). Ideally this should be real-time. I initially hoped replication from mySQL to SQL Server...

Ric

04-30-2007 01:46 PM
Ric

I have sql server 2005 publisher and sql server CE subscribers. To test the subscriber expiration I have kept - Subscription expire interval as 1...

Ravi Lobo

04-30-2007 11:48 AM
Ravi Lobo

One of my databases replicating on slow network channel. I compared amount of transactions per second which may be replicated with usage of SQL2k and...

andsm

04-30-2007 11:28 AM
andsm

Hello, I've a lot of sql server 2005 little databases, each one has its own publication to a mobile sql ce database. I'm searching a tool to...

franck

04-30-2007 10:17 AM
franck

I have two sql server instances on two different machines with the same db; on the first machine some tables need to be copied on the second...

mik

04-30-2007 05:58 AM
Paul Ibison

I have a very large and very active table which I want to replicate to another server. How can I set-up a Publication for this table and avoid...

Cqlboy

04-27-2007 07:48 PM
Raymond Mak [MSFT]

Hi, I want via email to monitor transactional replication status such as still running, have some problem during retry, or re-initialize, etc....

Chen

04-27-2007 04:01 PM
Paul Ibison

Hi Guys, Am very new to replication and would like to request some advice about solving the following problem. I have a main database running on Sql...

Pete

04-27-2007 02:54 PM
Pete

I have to move a SQL Server 2000 database from drive to another on the same server because we are running out of space. I know the easiest way to...

stevekelley4@gmail.com

04-27-2007 09:58 AM
ponnu

Hi all, We have a configuration where a SQL server mirrored database is setup to replicate to a different server. A remote server is used as...

Dalmer Azevedo

04-26-2007 05:28 PM
Dalmer Azevedo

I'm developing on SQL Server 2005 and our application needs to be 'replicable'. I can see how this is done using a RowGuid and marking to be used for...

Brian

04-26-2007 05:19 PM
Paul Ibison

Hi, Can anyone please provide me with a step-by-step explanation on how to replicate data (snapshot replication) from a table in a SQL Server 2005...

ronald.debruin@ecorys.com

04-26-2007 11:58 AM
Hilary Cotter

we are running sql200 and i am trying to do a transactional replication, i recieve the following error message during snapshot creattion The process...

Mark Alejandro

04-26-2007 11:44 AM
Paul Ibison

Hi, SQL Server 2000 on Windows 2003 server. We have been replicating between databases on the same server using snapshot replication for some time...

David Gray

04-26-2007 09:40 AM
Piku

Hello, I cant remove subs from the merge pub to sql compact edition... Its nowhere in the GUI like normal mege repl to sql express-- I tried all...

S c o t t K r a m e r

04-26-2007 09:26 AM
S c o t t K r a m e r

Hi I get the error: "A failure occurred when accessing 'tabelle1_2.sch' due to an operating system error during Web synchronization. Ensure that...

Urs Laubli

04-26-2007 07:15 AM
Urs Laubli

Has anyone else noticed that merge replication is slower on SP2 than SP1? We had an unfortunately situation where we has SQL 2005 SP1 + Hotfixes...

Cheval

04-25-2007 11:50 PM
Cheval

Hi, We are in the process of configuration replication for our 64-bit clustered sql 2000 environment. We run into this very common error, in the...

Tony

04-25-2007 08:53 PM
Hilary Cotter

The only way it can be done is to stop all log reader agents. Backup up the master, msdb, and distribution database(s). Install a new...

Hilary Cotter

04-25-2007 08:33 PM
Hilary Cotter

Any suggests on Agent is suspect error? MJ

mj

04-25-2007 11:20 AM
Paul Ibison

I got 2 servers running, Dev and Production The Production one is the one that the users run on and it's working with a Access adp project The Dev...

Franck

04-25-2007 10:33 AM
Franck

Hello, New to SQL Replication. Have SQL 2000 and wanted to replicate my business & core databases to a server at another site to increase...

Mrpush

04-25-2007 10:32 AM
Paul Ibison

I have a table that I need to replicate twice. Once as part of an updating subscriber transactional publication and once as a plain transactional...

Simon Sabin

04-25-2007 09:57 AM
Charles Wang[MSFT]

I cannot merge replicate a db from a PPC to a SQL Server 2K. After having followed each and every step of the tutorial by msdn: "Step by Step:...

patakioutas

04-25-2007 09:48 AM
patakioutas

hi, My setup has a centralised subscriber (SQL 2005) and multiple publishers (SQL 2000 , SP4) connected via Transactional PULL model. I had enabled...

Lavanya

04-25-2007 06:18 AM
Lavanya

Hi, My setup uses central subscriber (SQL 2005) with Transactional Pull model and all publishers are in SQL 2000 (SP4). I had enabled replication...

Lavanya

04-25-2007 05:40 AM
Lavanya

Hi guys, I have issue related transaction replication and trigger. In my company, we have transaction replication and then there are some triggers in...

Iter

04-25-2007 04:28 AM
Paul Ibison

after runnning removedbreplication on the subscriber, On the publisher I re-ran a publication: it failed with the process could not deliver the...

mj

04-24-2007 10:52 AM
mj

How The process could not drop one or more tables because the tables are being used by other publications

mj

04-24-2007 08:52 AM
mj

I am wondering how to set up replication. Say you have a very slow connection to a subscriber, so you want to minimize the amount of data...

Greg Larsen

04-24-2007 07:58 AM
Joseph

Environment: Merge Replication Publisher: SQL Server Enterprise 2000, SP 4. Subscriber: SQL Server Enterprise 2000, SP 3a We ran into an issue when...

mj

04-24-2007 07:36 AM
mj

Dear All, When I am synchronizing the merge push subscription, receiving following error Cannot find the identity range allocation entry for the...

M. M. Ansari

04-24-2007 06:58 AM
Hilary Cotter