Skip to content

Latest commit

 

History

History
43 lines (33 loc) · 2.34 KB

add-articles-to-and-drop-articles-from-a-publication.md

File metadata and controls

43 lines (33 loc) · 2.34 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords monikerRange
Add & drop publication articles (SSMS)
Describes how to add articles to and drop articles from a publication using SQL Server Management Studio (SSMS).
MashaMSFT
mathoma
09/25/2024
sql
replication
how-to
updatefrequency5
articles [SQL Server replication], dropping
deleting articles
dropping articles
adding articles
articles [SQL Server replication], adding
=azuresqldb-mi-current||>=sql-server-2016

Add Articles to and Drop Articles from a Publication

[!INCLUDEsql-asdbmi] Initially add articles to a publication when you create it in the New Publication Wizard. For more information about using this wizard, see Create a Publication.

After a publication is created, add and delete articles on the Articles page of the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see View and Modify Publication Properties. For information about the considerations for adding and dropping articles, see Add Articles to and Drop Articles from Existing Publications.

To add an article after a publication is created

  1. On the Articles page of the Publication Properties - <Publication> dialog box, clear the Show only checked objects in the list check box. This allows you to see the unpublished objects in the publication database.

  2. Select the check box next to each article you want to add.

  3. Select OK.

To delete an article

  1. On the Articles page of the Publication Properties - <Publication> dialog box, clear the check box next to each article you want to delete.

  2. Select OK.

Related content