I have a VB application that copies data from a table on server A to a table on server B. Whenever the value to be copied from server A is 0 it is written to server B as a Null value. I have tested the application on another PC (using different SQL servers) but cannot replicate the problem (the value is correctly written as a 0).
Is there a setting in SQL Server that treats values of 0 as Null values? If there is how do I turn it off?