Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
natrio
Starting Member
7 Posts |
 Posted - 2002-02-26 : 23:29:02
|
| Hi group,I want to delete all conflict replication tables and stored procedures that show up in my database (conflict_* tables and sp_cft* SPs)I've dropped the publication, even dropped the publication database, but the tables are still there.Anyone know how to do this?Thanks in advance |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-27 : 00:17:45
|
| I think sp_removedbreplication will do it.-Chad |
 |
|
|
natrio
Starting Member
7 Posts |
Posted - 2002-02-27 : 00:40:27
|
| After I run the SP, the tables and SPs are still there.FYI, I remove the publication through Enterprise Manager.Any other way? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-27 : 00:58:11
|
| After that SP is run, they can safely be deleted.Be sure you have a backup before deleting them, just in case something gets mucked up, but I have deleted those tables before after completely removing replication, and there were no ill effects.-Chad |
|
|
|
natrio
Starting Member
7 Posts |
Posted - 2002-02-27 : 01:07:19
|
| I can't delete the tables and the SPs because the types are "system", not "user". How can I change this type? |
|
|
|
|
|
|
Deleting all conflict replication tables and sp