because it is being used for replication

  • hi i want to delete database.i used this for replication in past.but i delete publisher and publication.no more replication exist.but it still give me error when i try to delete it.what i do error is like this because it is being used for replication

  • What error is it giving you?

    I'm betting the distributor is still set up. Or the subscribers.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • thanks for reply.

    sir i delete subscriber and publisher

  • You said nothing about distribution, so here's a link. Check everything:

    http://technet.microsoft.com/en-us/library/ms152757.aspx

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Try this:

    EXEC sp_MSunmarkreplinfo 'databaseName'

    Jared
    CE - Microsoft

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply