April 22, 2005 at 2:30 pm
Ofcourse, Any thoughts, any ideas....
April 25, 2005 at 2:44 pm
I am officially stopping to followup with this topic. Any ideas are welcome. I will check this once in a while.
Thanks in advance
July 11, 2011 at 6:44 am
the status values are additive. So 17 means the article is active and uses parameters.
March 29, 2012 at 3:02 pm
I know this is an old post but I also ran into the questions while working with replication and figured I would post my findings in order to help anyone else who comes across this post.
When setting the @status the values of 1,8, 16,24 are correct values to use. The reason why sp_helparticle returns value + 1 is because as another poster said its cumulative. When you see it plus 1 this is an indication that the article is active. If the article was not active then you would see the value of what you initially put in (8,16 or 24). The only time I have seen an article not active is when I have used sp_addarticle which brings me to your next question. You are correct in the behavior, when you add an article through the GUI it will create it and activate it. When you use sp_addarticle it does not activate it. I had to run profiler when adding through the GUI to figure out what i was missing. After adding an article using sp_addarticle you also need to run sp_refreshsubscriptions to activate it.
I ran across this link that really helped me understand.
Hope this is helpful!
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply