Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pulsar6
Starting Member
1 Post |
 Posted - 2003-02-03 : 07:14:01
|
| We have 3 identical databases in 3 different locations,housed in identical servers.Using transactional replication I get this error message;"Cannot insert a non-null value into a timestamp column.Use insert w/a column list or w/a default of Null for a timestamp column." How can I avoid this problem? |
|
|
mongr1l
Starting Member
1 Post |
Posted - 2006-03-09 : 14:07:45
|
| was there ever an answer to this? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-10 : 05:10:42
|
| are you experiencing the same problem?if yes, the message means that you are not allowed to replicate a non-null (with value) to a timestamp data type...db1-->db2-->db3val1-->null-->nulldo not propagate val1 because timestamp is created upon insert/update of the row, follow the advice on the error message...HTH--------------------keeping it simple... |
|
|
|
|
|
|
Non-Null values