Removing system replication tables.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MariaGuzman

    Removing system replication tables.

    Hi, i restored a backup from a database thas has replication configured.
    When i restored it the system tables that the merge replication creates
    are restored too. I was investigating on internet and I found that i can
    delete it using this query:

    sp_configure 'allow updates', 1
    go
    reconfigure with override
    go

    DROP TABLE aonflict_SiacDa taEEC_security_ info
    ...

    sp_configure 'allow updates', 0
    go
    reconfigure with override
    go

    Do somebody know if i use this queries to delete this tables i can
    damage the database or is correct to use it.

    Thanks a lot for your help.



    *** Sent via Developersdex http://www.developersdex.com ***
  • Simon Hayes

    #2
    Re: Removing system replication tables.

    You might get a better response in
    microsoft.publi c.sqlserver.rep lication

    Simon

    Comment

    Working...