Hello there. I have publisher and subscriber. In one of my tables the new data is being added, and old data is being deleted. Is there a way on...

Roy Goldhammer

02-04-2010 11:22 AM
Will Spurgeon

All servers are running SQL 2005. I have several remote locations that replicate via transactional replication to a central location (NOLA), the SQL...

LPR-3rd

02-04-2010 10:57 AM
LPR-3rd

許多性能å•�題和安全性您的計算機é€*æˆ�惡æ„�病毒，最好的辦法å°�付，這是得到承èª�和防病毒在計算機上安è£�æ›´æ–° æ...

antivirus gratis

02-02-2010 06:33 PM
antivirus gratis

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-01-2010 12:46 PM
Mia

Hi SQL Monster, I have 2 database server. One run real time I want to create replication on local network for snapshot or merge Can you help me ?...

PhuongNguyen via SQLMonster.com

02-01-2010 03:33 AM
PhuongNguyen via SQLMonster.com

i have configured transactional replication. Publisher and distributor on same server ,when data is transmitted from distrubutor to subscriber...

venkat reddy

01-30-2010 12:51 PM
NMahmoud

Hi, I am new to replication and after setting up trans replication, I add the table below at publisher and want to synch to subscriber only this...

LN

01-30-2010 11:52 AM
NMahmoud

Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado...

antivirus gratis

01-29-2010 07:46 AM
antivirus gratis

According to Microsoft, "If any column that is part of a unique constraint is updated, then SQL Server implements the update as a 'deferred update'....

Aaron Sentell

01-29-2010 06:53 AM
Aaron Sentell

Hi, We are using Merge replication between SQL Server 2005 and 2005 Express edition. Sometimes due to retention period or someother issues we are...

Manoj Rastogi

01-28-2010 01:02 PM
Manoj Rastogi

SQL2K SP4 on both Publisher and Subscriber. Remote Distributor (on the Subscriber). NOT immediate-updating. Transactional. Continuous. I've had...

ChrisR

01-28-2010 12:01 PM
Musawar

I have transactional replication running. I have a stored procedure that deletes a record which I would like to add to the publication via a...

Mark Price

01-28-2010 07:17 AM
Mark Price

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

01-27-2010 03:41 PM
antivirus gratis

Guys, I need to increase the login timeout on a few of my publishers, but adjusting the agent parameters on the distributor seems to have...

Joseph

01-27-2010 03:09 PM
Joseph

Using Transactional Replication. SQL Server 2008 SP1 x64. (Windows 2008 R2) Replicating permissions for non dbo schemas causes an error when...

jk

01-27-2010 01:42 PM
Paul Ibison

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

01-26-2010 03:05 PM
antivirus gratis

Hi ! We are attempting to write an app that simplifies Replication in as much as it will Publish / Subscribe and Synchronise ... We have used SQL...

Mark Rendle

01-25-2010 11:06 AM
Mark Rendle

Hi, We have a setup of merge replication. Currently one of the subscription shows it is running. Though the servermonitor does anot show any activity...

Jack

01-22-2010 10:31 AM
Jack

I received this error message from one of my SQL 2005 Servers ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ SQL Server detected a logical...

LPR-3rd

01-21-2010 02:31 PM
LPR-3rd

We currently have SQL 2000 to SQL 2000 merge replication. Can we upgrade the publisher to SQL 2008 and still do merge replication to sql 2000...

elpepe

01-21-2010 12:41 PM
Paul Ibison

Hi, I'm getting the following error on SQL Server 2005 Error messages: The Merge Agent failed after detecting that retention-based metadata...

NeilWake

01-19-2010 01:42 AM
Koen Mestdagh

A customer of ours receives the following message as soon as we try to add a subscription to a compact framework database. The process could not...

Jack

01-18-2010 03:04 AM
Jack

Hi all, I moved a replicated database from a SQL server 2005 box to a new SQL server 2008 box. I removed the replication from 2005, backed up the...

jaylou

01-16-2010 09:52 AM
Paul Ibison

Hi, I am setting up transaction log replication with a view to having a failover/reporting server available (more reporting really as failures are...

Alex_tring

01-15-2010 01:55 PM
Hilary Cotter

Hi, I set up transactional replication between two databases. When I applied the generated snapshot to the subscriber, I realized that the indexes...

Yanick Mongeau

01-15-2010 12:51 PM
Hilary Cotter

I know that I can alter the location of a snapshot both by setting the default snapshot location, or by specifying the...

Ben

01-15-2010 09:18 AM
Ben

Hi, Is is possible to configure standard transactional replication if my local distributor and publisher is SQL SERVER 7.0 and my subscriber is SQL...

Benjamin Fallar III

01-09-2010 01:40 PM
Paul Ibison

We have a merge replication implemented to our production envronment. I would like to create a non-cluster index on the publisher database. Here I...

Arunesh Mohan

01-09-2010 04:03 AM
Paul Ibison

I would like to stop sqlagent on the publishing server to halt replication. Then run couple of dml updates. Then startup sqlagent. Will the...

RG

01-06-2010 02:16 PM
RG

I have setup a snapshot replication with "Delete data. If article has a row filter, delete only data that matches the filter." article option. The...

CEN05

01-06-2010 11:23 AM
CEN05

Hi, I am using SQLserver2005 Oracle replication function to replicate data from Oracle10g DB. I found that the log agent showing 'The replication...

stephanie

01-06-2010 03:04 AM
stephanie

Do you think it's due to a merge filter type. I have a view with joins as the filter for the transactional replication. -- dev 2005 "Paul Ibison"...

CEN05

01-05-2010 02:09 PM
CEN05

Hi, I experienced a merge replication on my Db (on sql server 2000). I have delete the replication and the pubblication from Db but there are any...

rinoUGI

01-04-2010 12:18 PM
Paul Ibison

Hi, I am new to SQL replication replication, so please pardon me if my questions sound stupid. I have setup Transaction replication between SQL...

bharath_r

12-30-2009 07:56 AM
Paul Ibison

Hi All, I am trying to setup a replication from oracle to sql. The articles contain special characters (such as Euro sign). I tried with couple of...

siddu

12-29-2009 06:35 AM
siddu

What causes trans replication to throw up the error below?? And how to fix it without dropping the article, re-adding it & manually...

LPR-3rd

12-25-2009 01:31 PM
Paul Ibison

I would like to know if I add a new trigger to the Publisher database of a transational replication, it will be replicated to the subscribers. If...

Claudio-ExpertsInfo

12-22-2009 05:39 PM
Paul Ibison

I set up Transactional replication between two servers which failed. I removed the Publisher, Subscriber and Distibuter from both servers. I...

Greg

12-22-2009 05:23 AM
hilary

hello there I have a transactional replication which transfare data from two different serves on different location. The last data on publisher...

Roy Goldhammer

12-20-2009 07:50 AM
Roy Goldhammer

I want to use merge replication to replicate data for a grocery chain, and they obviously already have existing databases. In the past I've set...

brandonvmoore

12-20-2009 07:50 AM
Paul Ibison

Hello, I need a reference to basic information (white paper) on SQL web replication. Also, is this feature available in SQL 2000? Regards Yba

Yba

12-16-2009 07:56 AM
Hilary Cotter

I have set up a publication but can't get the snapshot agent to start. I get the message: The replication agent encountered a failure. See the...

Greg

12-15-2009 09:06 PM
Greg

Hello! We had maintenance on distribution server (separate from Publisher and Subscriber) and after Server restart I noticed that I constantly...

Igor Marchenko

12-14-2009 04:24 PM
Igor Marchenko

It's been a heated discussion in the office now whether our Distribution database should be on FULL or SIMPLE (default) recovery model, and I...

Aramid

12-14-2009 01:53 PM
hilary

We have a production hotel reservation system database in SQL2005, and we publish a table subset (mainly price and room availability) to several...

Corin Grieves

12-12-2009 03:14 PM
Paul Ibison

I inherited a SQL Server 2005 database mirrored server. The application server needs to be rebooted that corresponds to the mirrored server. ...

Joe K.

12-10-2009 07:27 AM
Joe K.

I have numerous subscribers which go offline for months sometimes but I dont always know for how long. If I set the retention period for 2 weeks,...

Kevin J

12-09-2009 11:50 AM
Hilary Cotter

Environment Replication: Transactional Source Server: OS: Windows 2003 Enterprise Edition, x64, 2 node Custer SQL Server: 2005...

mj

12-08-2009 12:37 PM
Hilary Cotter

Hi , I have a merge replication between a SQL server 2005 to a SQl server 2000 database. The data structure and the index etc are the same in both...

RK

12-08-2009 08:37 AM
Hilary Cotter

ultra short version: I need a way to delete a particular command (in the system tables) that's not applying correctly. Long version: I added a table...

M Bourgon

12-07-2009 11:54 AM
M Bourgon