SQL server 2000 replication
Posted on 2009-05-22
I have a database that is replicated in 2 subscriptions, one merged and one transactional. The replications are up and running and now I want to drop 2 columns that are in one of the replicated table. I am using the MS-SQL built in stored procedure:
exec sp_repldropcolumn @source_object = 'table_name', @column = 'column_name'
but it fails with:
Server: Msg 3701, Level 11, State 5, Line 1
Cannot drop the view 'syncobj_0x3046463231323742', because it does not exist in the system catalog.
Server: Msg 6401, Level 16, State 1, Procedure sp_articlecolumn, Line 701
Cannot roll back articleview. No transaction or savepoint of that name was found.
Server: Msg 21284, Level 16, State 1, Procedure sp_repldropcolumn, Line 652
Failed to drop column 'column_name' from table 'table_name'.
I am beginner with replication problems, please help.