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

12-04-2009 07:47 AM
Mia

Hi I've managed to set up my peer-peer replication under 2008, and have since been digging around the net about information relating to administering...

Ron

12-03-2009 12:26 PM
Ron

I have a SQL 2005-2005 Express Merge replication. Articles with FKs. Added a new subscriber, when I initialize it, some tables are updated more 190...

=?Utf-8?B?Sm9obiBMdW8=?=

12-02-2009 04:20 PM
Paul Ibison

We have several large views (100G to about 800G) of horizontally, locally partitioned data 2005. Now, when I say horizontally partitioned, I mean...

CLM

12-01-2009 03:47 PM
CLM

I searched the group for 'linked servers and replication' and see one post back in 2005 about how replication does not create linked servers. I need...

Paul

12-01-2009 11:37 AM
Paul

I have one problem. Replication to one of subcriber in merge replication stop synhronizing. Both, publisher and subscriber, are SQL 2005 SP3. This...

Gregor

11-30-2009 10:07 AM
Paul Ibison

Thanks Paul, "Paul Ibison" <Paul.Ibison (AT) ReplicationAnswers (DOT) Com.(donotspam)> table, how to transfer/sync to subscriber?

11-27-2009 02:18 PM
Paul Ibison

I am looking to move my distribution db log file to a new drive. To me I can follow the steps to move a system database files other than the master...

dbaeiss

11-27-2009 10:53 AM
Hilary Cotter

Hi there I've got a conflict that I'd like to investigate, to see what the offending transaction was. For example A conflict of type...

Ron

11-27-2009 04:59 AM
dbaeiss

NULLS are allowed at the publisher. -- Kevin J "Paul Ibison" wrote:

Kevin J

11-26-2009 02:00 PM
Paul Ibison

Hi NG, for SQL2k0 I have wrote my own tablediff with sync scripts. I read that 2k8 comes with tablediff.exe. My transactional replication used...

Thomas Hase

11-25-2009 04:51 AM
Thomas Hase

Thank you for your reply, Paul. It´s a very useful Article, but I´ve done exactly the described steps and nothing appears in the WSM. Do you have...

Karsten

11-24-2009 01:11 PM
Del

Hi, I have a problem regarding euro symbol (?) replication from Oracle to SQLserver2005. At oracle side we have a column containing ? (euro...

siddu

11-24-2009 10:29 AM
siddu

Hi NG, MSSQL2k8 Transactional Replication How can I find with T-SQL for a known publication the name or ID of the related task for logreader-task,...

Thomas Hase

11-24-2009 09:26 AM
Thomas Hase

Hello there, Actually, subject tells almost everything. We have a database which is > 1TB in size and we use Partition Switch feature for some...

Depp

11-24-2009 01:21 AM
Depp

We have multiple instances of transactional replication. (All using the same publisher/distributor, with various subscribers.) There are three...

Terry Steyaert

11-23-2009 12:59 PM
Paul Ibison

In my setup I have both Transactional publications and Snapshot publications. My understanding is that the Snapshot publication does not track or...

jk

11-23-2009 12:06 PM
jk

I have a number of merge publications on my 2005 DB with SP2. The server is currently located in our office and I am in the process of setting up...

Kevin J

11-22-2009 11:15 AM
Paul Ibison

hi, i defined a transational publication in server 1 and when I try to add a subscription in server 2, cause server 1 database access very slow,...

11-21-2009 10:06 AM
Paul Ibison

In trying to add 3 new articles to an existing publication, I'm encountering a small problem. Namely, after the snapshot is generated for these...

Ben Thul

11-21-2009 09:56 AM
Paul Ibison

I have performed a transactional replication in my company. However, all subscribers are not always connected to the editor/publisher. I have this...

wadii boulila

11-21-2009 09:53 AM
Paul Ibison

Hi, I wanna to work on my project with Transactional (with Update) Replication in distribute offices, it works fine. But I found if the Publisher...

KC

11-21-2009 09:43 AM
Paul Ibison

Hi, I am configuring Merge replication for one of our new critical project..This project has requirment to have servers on multiple locations..Here...

nj

11-21-2009 09:03 AM
Paul Ibison

I had 3 servers 2 transactional servers and one is main server i.e., Multiple Publishers and Single Subscriber A(TRANS SERVER) B(TRANS...

SATISH

11-21-2009 08:21 AM
Paul Ibison

Hi, when trying to delete a publication, error: could not delete publication '\publicationname' Addition information: An exception occurred while...

11-20-2009 06:46 AM
Hilary Cotter

Dear all I have spent quite a day or so dealing with an issue that I can make little sense of, I hope that someone has had a similar experience and...

Ron

11-20-2009 05:40 AM
Ron

We're using merge replication, and there are triggers on tables in other databases that update a replicated table. There is an after insert trigger...

amarshall@comporium.net

11-19-2009 09:33 AM
amarshall@comporium.net

Hi, I am a newbie and facing a replication task involving SQL Express 2005 and SQL Server 2008 standard edition. We have developed a POS application...

auspicious

11-18-2009 10:52 AM
Hilary Cotter

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...

Mia

11-18-2009 07:28 AM
Mia

Saddenly during generation of merge snapshot I get this error The process could not create file...

Matic Željko

11-11-2009 11:33 AM
Hilary Cotter

Hi All. I have a table published using transactional replication (Sql2k+Sp4), and in this table I have a blob column. I update this table/field...

Wilker Bezerra

11-09-2009 06:58 AM
Paul Ibison

Hi Paul thank you for your response. This problem already occured two times within one month. It's really annoying, because the only "solution" I...

Thomas

11-09-2009 03:45 AM
Thomas

Hi all, To explain my question, imagine there are three tables: Authors, Titles and TitleAuthor. Author_ID column is the PK on Authors. Title_ID...

Leila S

11-08-2009 01:46 PM
Paul Ibison

Here is my configuration SQL 2005 on all servers I am attempting to replicate a table described below: Server A -> Server B -> Server C and Server...

LPR-3rd

11-08-2009 01:22 PM
Paul Ibison

I have a SQL Server 2005 mirroring set up on my database server. Please help me with the procedures to re-establish mirror on this...

Joe K.

11-08-2009 01:18 PM
Paul Ibison

I am using SQL Server 2005. I have been having some replication issues overnight. My plan is to diagnose these issues using the output parameter...

JDS

11-08-2009 12:38 PM
Paul Ibison

Hi All. I have a table published using transactional replication (Sql2k+Sp4), and in this table I have a blob column. I update this table/field...

Wilker Bezerra

11-08-2009 12:01 PM
Paul Ibison

Hi there I have set up transactional replication, and right clicked the publication, selected properties, and chosen 'Subscription options' However...

Ron

11-08-2009 11:58 AM
Paul Ibison

Hi experts, We replicate our two databases with merge replication. While we replicate tables completely without problem, we could not find a way to...

Fatih

11-08-2009 11:24 AM
Paul Ibison

Hello, I have a transactional replication set up, and must include 2 columns in a table that is configured for replication. I not have configured...

Alexandre-SP

11-07-2009 03:28 AM
Paul Ibison

Hi All: I've had two SQL 2005 servers in a primary-secondary transaction log shipping configuration for over a year. I recently checked the secondary...

geek-y-guy

11-05-2009 06:25 AM
geek-y-guy

When NewSequentialID generates a GUID, I am aware that is uses the machine's MAC address as part of the algorithm. Are there any other physical...

Tracy Bannon

11-04-2009 01:43 PM
Tracy Bannon

We are currently using SQL Server 2008, I have 5 tables I would like to add to the publication. We have one publisher and one subscriber. All 5...

Toni

11-04-2009 09:25 AM
Toni

Hi all I have set up transactional replication with an updateable subscription I have a publisher table having a column FRED with a default value...

Ron

11-02-2009 09:32 AM
Ron

Hello All, I have a transactional replication using SQL 2000. One of the tables is around 300 million records. This has Timestamp column I am not...

satyendra

10-31-2009 04:59 AM
hilary

Hi All. I have a table published using transactional replication (Sql2k+Sp4), and in this table I have a blob column. I update this table/field...

Wilker Bezerra

10-29-2009 12:41 PM
Wilker Bezerra

Hi, I have a hyperlink field in MS Access. I am migrating the database to SQL Server which doesn't have the hyperlink datatype. It works fine unless...

Rowena

10-28-2009 10:12 AM
Hilary Cotter

I wanna to design a client/server application with distribute backend database. I have SQL2008 Enterprise as central database in Headquarter. SQL2008...

KC

10-28-2009 10:09 AM
Hilary Cotter

SQL 2005 on windows 2003 Staring on Friday, the purblisher started receiving this error to one subscriber (the other subscriber is...

Darin

10-28-2009 10:01 AM
Hilary Cotter

Hello, I am trying to set up web synchronisation but when starting the Merge-Agent I always get the following...

Rolf

10-27-2009 03:20 AM
Rolf