Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

I came across an interesting case which took a lot of efforts and understanding SQL server stored procedure code in replication space to nail down. Therefore, I would like to share the same. Hopefully it will help some of you. => Created a publication using “initialize with backup” and got the below error when the subscriber…

1