Wednesday, March 7, 2012

Problem w/2005 to 2000 replication

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
"MikeG" <mgagne11@.comcast.net> wrote in message
news:Od0CSc9HHHA.1816@.TK2MSFTNGP06.phx.gbl...
> 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?
>

No comments:

Post a Comment