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. Join them; it only takes a minute:

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

Forgive this simple SQL Server question, but if I just want to remove a single stored procedure from snapshop replication (2008 SQL Server R2), if I call sp_droparticle, will it invalidate the entire snapshot, or just the snapshot on that article?

IE, I've got a big database, and I don't want to force a full snapshot generation again, does sp_droparticle only affect the snapshot for that single object?

share|improve this question

migrated from Jan 9 '13 at 8:28

This question came from our site for professional and enthusiast programmers.

up vote 2 down vote accepted

The idea of a snapshot is a point-in-time copy of the entire publication, so once you make a change that affects the snapshot, it's no longer valid in its entirety.

From here:

Dropping an article from a publication involves dropping the article and creating a new snapshot for the publication. Dropping an article invalidates the current snapshot; therefore a new snapshot must be created.

Once you call sp_droparticle and invalidate the snapshot, the publication cannot be subscribed to again until a new snapshot is generated.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.