Distribution Agent

Within Properties of a Publication, on the "Subscription Options", I need to
enable the option:
"Use a Distribution Agent that is independent of other publications from
this database"
However, this option is "greyed-out" on the properties screen.
How can I enable this option?
-- Will G.
Will,
can you try:
sp_changepublication @.publication = 'publication'
, @.property = 'independent_agent'
, @.value = 'true'
I'm at home at the moment and can't test it here.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)