SQL Server Performance

Says Table is Replicated when it's NOT

Discussion in 'Performance Tuning for SQL Server Replication' started by photura, Jul 18, 2006.

  1. photura New Member

    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?
  2. satya Moderator

    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.
  3. photura New Member

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

    Thanks.



    quote:Originally posted by satya

    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.

Share This Page