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 |
|
stu
Starting Member
1 Post |
 Posted - 2004-03-01 : 02:57:29
|
| I am developing an application that uses a db that is setup for replication between two servers. I am noticing that some of the data in particular columns on random records is missing. I am quite confident that the insert commands are inserting data correctly as I have tested this extensively. I am wondering if it is possible that the replication setup could be missing some columns when replicating? Usually it is just an empty string inserted rather than NULL value. I did not setup the replication, so I am not sure how to test this.Has anyone experienced this before or knows what the cause of this might be?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-01 : 13:15:09
|
| Is replication using stored procedures or INSERT,UPDATE,DELETE statements? This is configured when you setup replication. If using stored procedures, I would look at the stored procedures to see if someone has modified them and is not passing the columns. If using straight DML statements, I would suggest running SQL Profiler to determine what the problem is.Tara |
 |
|
|
|
|
|
Column data missing