Can SQLCE dsf subcribe to 2 publications from the same server database?

Is it possible for a sqlce database to subscribe to 2 publications publish
from the same server database?
I have the sqlce sdf file created from synchronize with the 1st publication
with the "AddOption.CreateDatabase".
Then later i created a 2nd publication from the same database in the server
and I want to subscribe to the new 2nd publication
in the same sqlce sdf file. I get the error "Initializing SQL Server
Reconciler has failed,,,,".
Below is my code :-
Dim repl as SqlCeReplication
--
If File.Exist("My Documents\Product.sdf") then
repl.Synchronize()
Else
repl.repl.Synchronize(AddOption.CreateDatabase)
End if
Not in SQL 2000. I believe it is possible in SQL 2005.
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
"Dickson" <fvhck@.pc.jaring.my> wrote in message
news:epplB%23lJGHA.1848@.TK2MSFTNGP12.phx.gbl...
> Is it possible for a sqlce database to subscribe to 2 publications publish
> from the same server database?
> I have the sqlce sdf file created from synchronize with the 1st
> publication
> with the "AddOption.CreateDatabase".
> Then later i created a 2nd publication from the same database in the
> server
> and I want to subscribe to the new 2nd publication
> in the same sqlce sdf file. I get the error "Initializing SQL Server
> Reconciler has failed,,,,".
> Below is my code :-
> --
> Dim repl as SqlCeReplication
> --
> --
> If File.Exist("My Documents\Product.sdf") then
> repl.Synchronize()
> Else
> repl.repl.Synchronize(AddOption.CreateDatabase)
> End if
>
>

Can one rename the underlying physical file name of a SQL 2000 database?

Gurus,
Can one rename the underlying physical file name of a SQL 2000 database?
I.E., bring the database offline, rename the physical file MDF and LDF name,
then safely bring the database back online again?
SpinYou can detach, rename, then re-attach.
Do have a good backup just in case.
-oj
"Spin" <Spin@.spin.com> wrote in message
news:4go8juF1ok79lU1@.individual.net...
> Gurus,
> Can one rename the underlying physical file name of a SQL 2000 database?
> I.E., bring the database offline, rename the physical file MDF and LDF
> name, then safely bring the database back online again?
> --
> Spin
>