if you did not specified index creation on the schema_option of your table articles the indexes will not be replicated.

You can usually see tran_seq_number and command_id on replication monitor.

Use those on sp_browsereplcmds and you will see which rows are the troublemakers.

Now to me it could be an indication...

There is one Book on replication that has step-by-step instructions on many of the setups http://www.amazon.com/Server-2005-Replication-Definitive-Guide/dp/1590596501

BUT it is mostly BOL with Pictures... Nothing ( or to me at least) is...

Kendal Van Dyke (3/27/2009)

---

Identity columns and replication are a dangerous combination for the central subscriber model, specifically because you can have a...

if you have two separated publications you should have no problems but I have never tried to create two separated publications going to the same subscriber DB.

Is that your case...

Just one clarification. publisher is a SERVER, publication is associated with a database.

- You can have MULTIPLE publications with ONE publisher and ONE database.

- In the same way you can...

Michael Wood (3/26/2009)

---

If you have the option to do some redesign of the application you might want to try something like:

Reading from your Inventory table, but updating your InventoryUpdate View...

Grant Fritchey (3/25/2009)

---

From conversations I've had with people who were on the committee, the DBA track has the fiercest competition. Since you're on that track... it'll be tough. But you...

That sounds sensible.

umar iqbal (3/25/2009)

---

Try not to run snapshot agent. I never do since it takes lots of resources. Alternatively

I backup and restore database to make them in synch .

once in synch...

Florian Reischl (3/25/2009)

---

Hi Noel

So I thought the OPENQUERY might be a better solution. I don't really know if the data are too much before or even after the grouping. Maybe...

Bad Idea to run such a query over a linked server if the table is big!

DDL of the tables, some sample data and some sample of the output you expect will help us help you.

Florian Reischl (3/25/2009)

---

Hi Richard

Thank your for your feedback. The sp_MSforeachdb also uses a CURSOR internally. See:

DECLARE @v-2 NVARCHAR(MAX)

SELECT @v-2 = definition

FROM sys.all_sql_modules

WHERE...

You can have one agent per publication, so there is nothing new about this.

If you have multiple publications going into one subscriber you will see multiple distributor agents.

There could...