November 9, 2004 at 10:15 pm
Hi
When adding a database to publications, the process gets stuck on the first article of the database. This only happens on databases that was previously replicated, others run through without the slightest problem. We also checked the transactions issued with sp_who2 / trace, it looks like the transaction goes into a loop of selecting and updating. We have checked all the replication related tables in an attempt to properly remove any traces of previous publication, but to no avail. Can anyone help?
Thanks
Emile
November 10, 2004 at 12:19 pm
You should create the publication and add all the articles using system stored procedures.
You will need to use sp_replicationdboption, sp_addpublication, sp_addpublication_snapshot, sp_grant_publication_access, sp_addarticle and sp_addsubscription sps, for transactional replication.
Also you can add the articles using sp_AddArticle one by one.
November 10, 2004 at 10:03 pm
Hi
Thanks racosta, we already tried that, with no luck. Further testing revealed that individual tables not previously published also work fine. We then tried selecting the contents of a table that could not be puclished into a temp table, dropping the original, and selecting the temp contents back into a table with the original name, effectively re-creating the table. This worked, it looks like the system id's etc in sysobjects got messed up, for what reason we are not sure yet.
Regards
Emile
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply