I initially set up replication temporary and it removed.
Now we've noticed the id columns have ‘FOR REPLICATION’, immediately we executed sp_removedbreplication ‘dbname’.
After executing the sp, the id column now have ‘NOT FOR REPLICATION’.
How do you get rid of this NOT FOR REPLICATION from my id columns?
(id) INT IDENTITY (1,1) NOT FOR REPLICATION NOT NULL,