Saturday, February 25, 2012

Only 1 subscription for a SQL CE database?

Hi all,
I'm trying to use the SqlCeReplication object to add multiple subscriptions
to the database (.sdf). But when I try to add the 2nd one, I get an
exception with the message "The SQL Server CE database is already enabled for
replication." Does that mean for each SQL CE database, there can be only one
subscription?
Thanks,
Harold
Please ignore my question. I've found the answer:
No, SQL Server CE subscriptions can be made to only 1 publication (1
subscription per Database).
Kevin Boske
SQL Server CE Team
Microsoft
"Harold Hsu" wrote:

> Hi all,
> I'm trying to use the SqlCeReplication object to add multiple subscriptions
> to the database (.sdf). But when I try to add the 2nd one, I get an
> exception with the message "The SQL Server CE database is already enabled for
> replication." Does that mean for each SQL CE database, there can be only one
> subscription?
> Thanks,
> Harold
|||Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Harold Hsu" <HaroldHsu@.discussions.microsoft.com> wrote in message
news:1164C63E-8B0C-43A0-8471-1C3BED0948D2@.microsoft.com...[vbcol=seagreen]
> Please ignore my question. I've found the answer:
> No, SQL Server CE subscriptions can be made to only 1 publication (1
> subscription per Database).
> --
> Kevin Boske
> SQL Server CE Team
> Microsoft
>
> "Harold Hsu" wrote:
subscriptions[vbcol=seagreen]
enabled for[vbcol=seagreen]
only one[vbcol=seagreen]
|||sql server 2005 mobile supports more than one subscription per sql ce/mobile
database.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Harold Hsu" <HaroldHsu@.discussions.microsoft.com> wrote in message
news:1164C63E-8B0C-43A0-8471-1C3BED0948D2@.microsoft.com...[vbcol=seagreen]
> Please ignore my question. I've found the answer:
> No, SQL Server CE subscriptions can be made to only 1 publication (1
> subscription per Database).
> --
> Kevin Boske
> SQL Server CE Team
> Microsoft
>
> "Harold Hsu" wrote:
subscriptions[vbcol=seagreen]
enabled for[vbcol=seagreen]
only one[vbcol=seagreen]

No comments:

Post a Comment