Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When attempting to add a new subscription to an existing Transactional publication on 2008. It is all configured on 1 server as it is for Pre-Production testing.

I get the following error when attempting to create the new subscription.

Msg 20027, Level 11, State 1, Procedure sp_MSadd_subscription, Line 223
The article '(null)' does not exist.
Msg 14070, Level 16, State 1, Procedure sp_MSrepl_changesubstatus, Line 1208
Could not update the distribution database subscription table. The subscription status could not be changed.
Msg 14057, Level 16, State 1, Procedure sp_MSrepl_addsubscription_article, Line 383
The subscription could not be created.
share|improve this question
1  
Can you give us more details? What is the article that you added to this publication? – Thomas Stringer Nov 21 '12 at 13:10
    
I didn't add an article. I added another subscription to the publication that was already running. I would love to find out which article has somehow become (NULL) – DamagedGoods Nov 21 '12 at 16:26
    
--read to fast, sorry-- – Edward Dortland Nov 24 '12 at 0:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.