Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Question Unanswered: Dropping tables from a article

    Just a quick question , when you have a article is their any way to drop a table from a article.

    Don't know if it important but I'm using merge replication.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Ok.....what's an article?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    Originally posted by Brett Kaiser
    Ok.....what's an article?
    Sorry I suppose that should have been described as how do I drop a article from a publication. When the article is a table, or is a table a group of articles. Not hundered percent on the Publishing Metaphor.

    A article is part of a publication that is part use as part of replication.
    Any suggestions?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Sorry...haven't done replication, but looking up in bol, it looks like the correct terminology...

    Did you check out BOL?

    To delete an article



    Note Deleting articles from publications that have subscriptions is not allowed. To delete an article, you must first delete all subscriptions to the publication.

    At the Publisher, open SQL Server Enterprise Manager, expand a server group, expand the Replication folder, expand the Publications folder, right-click the publication, and then click Properties.


    Click the Articles tab, select an article to delete, and then clear the check box next to the article to delete.
    1988-2000 Microsoft Corporation. All Rights Reserved.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    I don't think there is. What I usually do is drop and recreate the article if I want to make a change.

  6. #6
    Join Date
    Jul 2003
    Posts
    100
    Originally posted by joejcheng
    I don't think there is. What I usually do is drop and recreate the article if I want to make a change.
    Brill, Just wanted to be sure. Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •