SQL server 2000 replication

Posted on 2009-05-22
Medium Priority
Last Modified: 2012-05-07
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.
Question by:Zberteoc
1 Comment
LVL 54

Accepted Solution

Vitor Montalvão earned 1500 total points
ID: 24465612
Unfortunaly in SQL Server 2000 you need to drop replication before deleting column that is being replicated.
I suggest you to script the replication before doing anything so you can recreate replication quickly.

Good luck

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question