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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-08 : 08:08:41
|
| peter writes "One of my database is used for merge replication. This database is loaded with huge number of system tables and system procedures presumably to be used by the distributer in the same server. There are only two publication as of now. But I have created many publications and deleted them all except the two existing now. Can we get rid of those system tables and procedures which are created during the publication using merge replication(presumed)?when i try to delete them, I get the message that they are system tables/procedures and are not deleted. It makes certain area of work very slow...Can somebody help me.Thank you" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-10 : 02:36:46
|
| have you tried sp_mergesubscription_cleanup?--------------------keeping it simple... |
 |
|
|
|
|
|
accumulation of system objects in replicated databases