Posted by MariaGuzman on 07/08/05 00:45

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_SiacDataEEC_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 ***

• Next in forum: Re: Combining Stored Procedures
• Prev in forum: Re: Combining Stored Procedures
• Thread view: Removing system replication tables.

[Reply to this message]