Post reply

get rid off NOT FOR REPLICATION property

  • December 9, 2018 at 9:20 pm

    #416543

    Hello,
    I dropped a local publication and a subscription, however I still see a table in publication database having NOT FOR REPLICATION property on Identity Column:
    [Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    What is the best way to get rid of NOT FOR REPLICATION property without affecting Identity
    alter table [dbo].[MyTable] alter column [Id] DROP NOT FOR REPLICATION
    or anything else?

  • December 10, 2018 at 5:03 am

    #2015857

    You can take a look at sys.sp_identitycolumnforreplication

    -Roy

  • December 12, 2018 at 3:55 am

    #2016078

    If you have identity column on the table that property will be ALWAYS there. Even when table is not published. That property is part of any identity column (with or without replication setup).

    BartL
    Replication Blog

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply