October 2, 2003 at 10:55 am
hi all expert,
I've create a publication (transactional) and then create a push subscribtion by this publication.
If i'm using the SQL enteprise manager to do that, the push subscribtion can be created and all the DB objects inside the artical will be copied into the subscriber database automatically when finished the wizard.
If l'm using T-SQL, the following is my step to do the same thing.
assume that the publication is ready.
1) sp_addsubscriber
2) sp_addsubscription
after completed the second step, from the SQL enterprise manager's replication monitor where i can see the created push subscribtion, however, the subscriber database is nothing, if i manually reinitial the subscribtion and start the snapshot agent then the DB object from artical only will be copied into the subscriber database.
I would like to know, after execute the sp_addsubscription command, should i need to run any command that to ask SQL server initial the snapshot ?
Please help
Thank you
October 2, 2003 at 11:34 am
I think its probably a param somewhere, probably at the publication level. Build a simple pub/subscription, script it all out, see what they are doing.
Andy
October 4, 2003 at 6:50 am
Thanks for your reply.
The problem had been resolved
after the subscription created, i should call the start job function to run the snapshot agent, then only the artical and all required system table will be copied into the subscriber database.
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply