Dist. Partitioned Views

I've read that the partitioning column must be part or
all of the primary key.
Is this design advice or a requirement? If it's a
requirement, why?
Any and all help appreciated,
Thanks,
Andrewit is a requirement, so that sql server will know to which
server the new row belongs. This is just to avoid
confilict and overlapping of the data on multiple servers.
>--Original Message--
>I've read that the partitioning column must be part or
>all of the primary key.
>Is this design advice or a requirement? If it's a
>requirement, why?
>Any and all help appreciated,
>Thanks,
>Andrew
>.
>sql

Dist Agent Setting

Running Win 2003 & SQL 2005
I had a problem with one of my dist agents & got backed up to the tune
of 1.55 million commands in the distribution database waiting to be
applied.
The agent has been running for 9+ hours and the number of pending
commands has not changed.
Is there a setting I can chang/make in the dist agent to get them to
process faster or atleast see the number of pending go down, so I will
know it is working.
AHIA,
Larry...
Larry - you could try reducing the -CommitBatchSize
nd -CommitBatchThreshold parameters and see if this helps.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com