From: Ron on
Hi Hilary

Thanks for that. I know of the setting you mentioned. I will rebuild the
publication checking this setting as I go to make sure it is set.

So basically, if it is set, then it should copy over the defaults?

Thanks

"hilary" wrote:

> Can you check to verify that when you created the publication you selected
> the option to replicate defaults?
>
>
> "Ron" <Ron(a)discussions.microsoft.com> wrote in message
> news:BB13DB98-9360-4D90-9AAA-8D0CD87ED3E2(a)microsoft.com...
> > Hi all
> >
> > I have set up transactional replication with an updateable subscription
> >
> > I have a publisher table having a column FRED with a default value of
> > (getdate())
> >
> > I noticed on the subscriber that this property hasn't been copied over, so
> > any inserts on the sub table are failing as FRED has is set to NOT NULL.
> >
> > Any thoughts, how can I ensure default value settings are copied over to
> > subscribers?
>