ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated

Question

We have a SQL Server 2012 database that was migrated from SQL Server 2000. The 2000 version had replication on it, but this was removed.

I am currently trying to remove a few deprecated columns in several tables, but I'm getting the following message:

ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated.

As far as I can see, neither the server nor the database have any remains of replication. The triggers, system tables - everything is gone.

Has anyone encountered this before?

Any replication related constraints in this table? – Brandon Williams Oct 25 '13 at 01:59 — Brandon Williams, Oct 25 '13 at 01:59

score 0 · Answer 1 · answered Oct 20 '13 at 20:28

0

I am not sure but maybe this will work try Executing this proc on Publisher Server

EXECUTE sp_repldropcolumn @tblname, @colname

and then try to alter your table.

answered Oct 20 '13 at 20:28

M.Ali

67,945
13
101
127

That was the first thing I tried, and I got back the response Msg 208, Level 16, State 1, Procedure sp_repldropcolumn, Line 191 Invalid object name 'sysmergearticles'. – user884248 Oct 21 '13 at 06:02

score 0 · Answer 2 · answered Oct 21 '13 at 02:44

If replication isn't supposed to be configured for this database at all, try dropping the hammer on it. Something like this:

exec sp_replicationdboption 'yourdb', 'publish', 'true', 1
exec sp_replicationdboption 'yourdb', 'publish', 'false', 1
exec sp_removedbreplication 'yourdb'

ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated

2 Answers2