default value after replication

Hi all,
I have problem when conducting the replication.
Some tables in subscriber side contain default values and null values
respectively. After replication, all these fields are blank.
Is there any setting to keep the default and null values repectively after
replication?
Thanks a lot!!
If this is transactional replication I suspect you will need to modify the
replication stored procedures to obtain the behaviors you are looking for.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Andrew" <andrew@.iplr.com.hk> wrote in message
news:uX0zZMxVGHA.3760@.TK2MSFTNGP15.phx.gbl...
> Hi all,
> I have problem when conducting the replication.
> Some tables in subscriber side contain default values and null values
> respectively. After replication, all these fields are blank.
> Is there any setting to keep the default and null values repectively after
> replication?
> Thanks a lot!!
>
|||Andrew,
have a look at the @.schema_option argument for sp_addarticle, which has a
value for defaults: 0x800.
AFAIR if you select the checkboxes on the article properties, you will end
up with the defaults added, even though it isn't explicitly mentioned.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
You're so great! It works now.
Thanks for you help again!!
Cheers!
Andrew
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ebsqhbyVGHA.5064@.TK2MSFTNGP10.phx.gbl...
> Andrew,
> have a look at the @.schema_option argument for sp_addarticle, which has a
> value for defaults: 0x800.
> AFAIR if you select the checkboxes on the article properties, you will end
> up with the defaults added, even though it isn't explicitly mentioned.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>