REPLICATION

[Guest_imported]

I've remove a replication made between two database,
now when I try make an ALTER TABLE, this is not possible because of "this table is being published for replication"
but ¿what replication? it doesn't exist now.

 

[aalmeida]

There is some clea up to be done after "Removing a Replication", when a replication is created it adds a timestamp column to all tables been replicated and several other things, you actually need to go there and remove all of these type of things manually AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[Guest_imported]

Thank very much for your answer, but I need you be more explicit, I don't know what things have to be removed.

 

[aalmeida]

I don't know what all you already have removed from the replication, The only thing I know it does not removes for sure is the time stamp columns from your table schema, but that is not what's keeping you from run an alter table script, you actually have to go through your server on EM and manually remove everything that referrs to replication on that database like: Agent Jobs, Replication instances and Jobs, schedulles etc... AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"