Hi I do have Publisher Table and Subscriber Table , both has same schema , Difference is publisher table has one computed column which return varchar Like Sample Below:
CREATE FUNCTION [cimfn_FormPartition](@pKeyVal BIGINT) RETURNS VARCHAR(100) WITH SCHEMABINDING AS BEGIN [LOGIC] RETURN @Output END GO **Publisher End:** create table table1 ( [pKey] [bigint] IDENTITY (1, 1) NOT NULL , [cKey] AS dbo.cimfn_FormPartition(pKey) PERSISTED, [id] [varchar] (20) NULL , [refId] [varchar] (20) NULL , constraint [pKey] PRIMARY KEY NONCLUSTERED ( pKey ASC) ) ALTER TABLE [table1] ADD CONSTRAINT [CI_Items] UNIQUE CLUSTERED ([cKey]) ON [PRIMARY] **Subscriber End:** create table table1 ( [pKey] [bigint] NOT NULL , [cKey] [varchar] (100) NULL, [id] [varchar] (20) NULL , [refId] [varchar] (20) NULL , constraint [pKey] PRIMARY KEY NONCLUSTERED ( pKey ASC) ) ALTER TABLE [table1] ADD CONSTRAINT [CI_Items] UNIQUE CLUSTERED ([cKey]) ON [PRIMARY]
In the Article Properties of publisher table All things I have set to false , and set ACTION IF NAME IS IN USE : Keep existing object unchanged When I insert data into publisher table then in subscriber tabel I am getting below output : **pKey cKey id refId 1 NULL Item1 i1** I Have addedd Article Proper and Even though subscription table is getting null value in cKey ,and all other column has correct value. I have check replication monitor as well , No error is showing there. I more drilled down with the store procedure **(sp_browsereplcmds)** and found out the insert command does not have computed column value with this. So now again question is why Distributor is not picking computed column from publisher?