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 |
|
netrid3r
Starting Member
2 Posts |
 Posted - 2010-03-30 : 04:10:49
|
I cant delete replication in my server.If I try to delete manually the system shows the next popup (sorry for the screenshor in spaniosh)If you try to delete the replicacion with the next query:use [master]exec sp_dropdistributor @no_checks = 1GOThe system throws the next error:Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 337El nombre de objeto 'sysarticles' no es válido.Mens 4413, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 337No se pudo usar la vista o función 'sysextendedarticlesview' debido a errores de enlace.Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 406El nombre de objeto 'sysarticles' no es válido.Mens 4413, Nivel 16, Estado 1, Procedimiento sp_MSrepl_dropsubscription, Línea 406No se pudo usar la vista o función 'sysextendedarticlesview' debido a errores de enlace.Mens 208, Nivel 16, Estado 1, Procedimiento sp_MSpublishdb, Línea 123El nombre de objeto 'syssubscriptions' no es válido.Many thanks... |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-30 : 10:41:33
|
| First drop the subscriptions, then the publications, then the distributor. |
 |
|
|
netrid3r
Starting Member
2 Posts |
Posted - 2010-03-30 : 11:20:54
|
| the replicacion config is corrupted... there is no any publication and subscription in SQLMANAGER.I dont know whats the problem... The error 208...Apparently the system always show errors with invalid system tables or views... when i try to enable the replication again or uninstalling it....probably some system views or configs are dissapeared. |
|
|
|
|
|
|
|
|
Delete replication error