Default Values on Column Names

[Gys]

Is there a real good reason to have DEFAULT VALUE on Column Names. (Replication problems)

The reason for my question is:
I'm Replication a Database from one server to another. When I do the Replication - Snapshot, I can't get it to replicate the Default Value of the Column Names on the second server. The data, etc. is on the second server, except the Default Values of the Column Names?

Please HELPPPPP!!

Thanks

 

[Tim1]

Hiya,

How have you defined the default value in the table? Have you done it via a default in the table DDL e.g.

DATE DATETIME DEFAULT getdate()

or via an sp_bindefault? If you have done it through the latter, you must create the default in your replicated database. If you have done it through the former, it should be taking the values with it.

HTH

TIm