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 |
|
pasttense
Starting Member
3 Posts |
 Posted - 2008-11-25 : 09:40:32
|
| Hello everyone,We have bi-directional transactional replication set up here between 2 servers, and except for this one issue, things are going well. Any table that has a bit field is only receiving a 0, even if the value is 1. I have profiled the commands being delivered and the problem is that SQL Server is sending a 0. I have searched for a setting somewhere and googled for a solution but haven't been able to find this issue anywhere else. I would be extremely grateful if someone had any experience with this or an idea of what could be causing this. Thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-25 : 09:46:45
|
| was there anything changed in properties of articles? |
 |
|
|
pasttense
Starting Member
3 Posts |
Posted - 2008-11-25 : 09:51:40
|
| Not since I created them. Here's an example of one of the scripts I used:exec sp_addarticle @publication = N'myPub', @article = N'Lab', @source_owner = N'dbo', @source_object = N'Lab', @destination_table = N'Lab', @type = N'logbased', @creation_script = null, @description = null, @pre_creation_cmd = N'none', @schema_option = 0x00000000000000F1, @status = 16, @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_dboLab', @del_cmd = N'CALL sp_MSdel_dboLab', @upd_cmd = N'CALL sp_MSupd_dboLab', @filter = null, @sync_object = nullI looked at that to see if there was a problem, but I pretty much just copied that from MSDN for setting up bi-directional replication. Also, since it's happening on every bit field in every table, I wasn't sure if it might be a problem with the publication. |
|
|
|
pasttense
Starting Member
3 Posts |
Posted - 2008-11-25 : 10:12:38
|
| One thing I forgot to mention is that this is only happening in one direction. From server A to server B, bits are being sent as 0's. From server B to server A, bits are being sent correctly. |
|
|
|
|
|
|
|
|
Bit fields being delivered as 0