Udostępnij za pośrednictwem


How to: Add Articles to and Drop Articles From a Publication (SQL Server Management Studio)

Initially add articles to a publication when you create it in the New Publication Wizard. For more information about using this wizard, see How to: Create a Publication and Define Articles (SQL Server Management Studio).

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 How to: View and Modify Publication and Article Properties (SQL Server Management Studio). For information about the considerations for adding and dropping articles, see Adding Articles to and Dropping 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. Click 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. Click OK.

See Also

Concepts

Publishing Data and Database Objects

Other Resources

How to: Define an Article (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance