Posted on 2005-04-12
Ok i have a DB that is the publisher for transactional replication.
I need to drop a column from a replicated table, so i go to Enterprise Manager - Replication - Publication - Properties.
There i select filter columns select the column and take the drop selected column action, NOTHING HAPPENS, i mean nothing, no errors it just hangs there for hours.
So i tried to sp_repldropcolumn sp with all the correct parametres in Query Analyser, SAME STORY, it just runs indefinately.
Profiler tells me nothing except that the statement has started?
What is going on?
Anyone please help!!!