sql server replication: Was the initial setup a nosync one? It seems that that was the case. If you
want automatic initialization, the easiest way is to drop the subscription
and then readd it and intialize. I know you're asking how to avoid this, but
I'm not sure why :)
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi ,

Actually before the deletion of the subscription it was already a
continuously updating replication when i generated the SQL Scripts.

i tot it could be eaiser to prevent the deletion and adding of the
subscription as i'll need to remember the replication type i.e queued or not

tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com

Hi,

I got the following message when after deleting the replication i tried to
recreate that replication using the SQL scripts that i generated earlier

the messages goes like this :

Subscription : SERVER1:SvrTT cannot be reinitalized automatically because it
was initalized manually when it was created. to reinitialized the
subscription you must drop and recreate it.

in the end i have to drop the recreate the subscription

ques :
1) how does this happened ? dun quite understand as i create the replication
from the SQL scripts that i generated earlier from the existing replication

2) how (if possible) can i not drop the subscription but allow the it to be
initialized automatically

appreciate ur advise

tks & rdgs

--
Message posted via SQLMonster.com