Thanks AlzDBA this is exactly what I needed.

I'm new at the whole index fragmentatation but have found that smaller tables may sometimes show increased fragmentation after rebuilding the index. Particularly lookup tables in my instance.

Cool, thanks for the feedback!

On closer inspection it turns out that the SQL login on the problem server was actually a system user group and not a Domain group like on the rest of...

Thank you very much for this, this is exactly what i'm trying to accomplish.

:hehe:

Okay problem solved ...

came across this on someones blog which is the equivelant to the ALTER Authorisation in SQL 2005

SQL 2000::hehe:

EXEC dbName..sp_changedbowner 'sa';

Validating a subscription will only notify if there are problems but it will not fix anything.

(I'm still new at this so someone should probably confirm).

You might want to check your...

Thanks Chris ! This was is what I was looking for.

Thank you Chris.

The problem I have is this though:

CoreItem 1 should not be returned because at least one of it's SubItem (1 and 2) have matching categories. Even if CoreItem3...

Hi my apoligies for the test data ... i've modified it a bit.

I'm trying to identify which CoreItem has SubItems with categories which do not correspond to any of the...

Thanks for this tip ... I just recently came accross a scenario where other means to remove the replicated...

I ran EXEC sp_helpmergepublication to see what the details of the publication were and it returned a backward_comp_level of 40.

Now I'm really confused because that level is not listed by...

Came accross something rather strange.

I examined the setup of each subscriber and found that the subscribers that were not experiencing timeouts were on SQL 2000 sp3...

The performance is still slower...

My bad ... was pretty sure I read somewhere that log shipping could not be used with 2005 / 2000 replication.

In any case books online lists all the details ......

Yes it is, you will however be limited to the abilities SQL 2000 in terms of replication. For example i think log shipping is not available in 2000.

Cheers.