SQL Server Performance Forum – Threads Archive

Says Table is Replicated when it’s NOT

When I try to run: ALTER TABLE [dbo].[Table_Name] DROP COLUMN [Column)Name] I get this error: ALTER TABLE DROP COLUMN failed because ‘Column_Name’ is currently replicated. It’s Not. I’ve checked sysobjects in that database and for that column replinfo is set to 0. I’ve run drop replication and it still doesn’t work. I’ve run sp_MSunmarkreplinfo and still still thinks it’s being replicated. Replication is not on this server at all. So, does anyone have any other troubleshooting ideas?

---

Try modifying the publication in this case, as it seems the process is trying the replicated column. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

---

Unfortunately, there isn’t a publication on this server to modify. That’s the mystery. Any other thoughts? Thanks.

---

]]>