When I add the option to add extended properties to the publication, create
the snapshot and then distribute I get the following error in the
distribution agent task:An invalid parameter or option was specified for
procedure 'sp_addextendedproperty'

Any ideas?

Nothing in the documentation that I could find to explain this - it may be a
bug. I'll see if I can reproduce on Monday.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Hi Mike,

While our documentation states that replication from SQL2005 to SQL2000
subscribers is supported, I will be the first to admit that the support is
by no means perfect as we don't really have a general schema translator that
can perform what would be considered reasonable mapping of SQL2005
syntax\functionalities to SQL2000 "equivalent". As such, I am not really
surprised that you are running into problems when replicating extended
properties from SQL2005 to SQL2000, but I would really appreciate if you can
use SQL profiler to capture the problematic 'sp_addextendedproperty' call
from the distribution agent and post [a sanitized version of] it here so we
can decide if we can do something about it or perhaps suggest a workaround
(one possibility is to disable extended property scripting for the
problematic article and put the extended property definitions in a
post-snapshot script). At this point, I would hazard a guess that the
problematic call probably contains @level0type = 'SCHEMA' in it.

Hope that helps,

-Raymond

[quoted text, click to view]