sql server replication:
The specified subscription type is invalid.


The specified subscription type is invalid.
(Source: Merge Process (Agent); Error number: -2147201020)
------------------------------------------------------------------------
----------------------------------------

--

From your post heading, looks like you want a pull subscription.

Could you confirm that the merge agent parameter -SubscriptionType is
correct..

Pull susbscriber: -SubscriptionType 1
Anonymous subscriber: -SubscriptionType 2

Hope that helps.
--Mahesh

This posting is provided "as is" with no warranties and confers no rights.


[quoted text, click to view]

I'm new for replication. How can I check it?

--

If you are using a command line merge agent, you can pretty much specify
what you want on the command line.

If not, if you are using jobs to run the merge agent, then look at the job
steps and see what is specified in the job description.
In Enterprise manager, select Management-->Jobs-->
Right click on the job displayed on the right hand side, select properties,
select "Steps" tab, double click on the "Run Agent"
and see the description in "Command"

Verify that you specified a pull subscription and it is SubscriptioType 1 in
the Command (as mentioned above)

Another way you could check is:
verify that column subscriber_type in the system table sysmergesubscriptions
at both the publisher and subscriber database is the same. In this case,
since it is pull, it should show value as 1.

Hope that helps.
--Mahesh

This posting is provided "as is" with no warranties and confers no rights.


[quoted text, click to view]