Need Serious Replication HELP!
I have a situation where I have synched up the data bet publisher and subscriber manually, and then put in a custom sp_MSupd_table stored proc which is called when there is an update. However upon synch, I get the following error failure: Cannot insert the value NULL into column 'ColID', table 'DB.dbo.MyTable'; column does not allow nulls. UPDATE fails.
Here is my SP: (I've changed the name references to protect the innocent.
Profiler shows its passing NULLS. If one can help me understand how the values get to the SP parameters during REPL. Or, tell me what I am missing. Do I need CASE WHEN statements? But if COL=NULL what value would be passed?? TIA
CREATE procedure sp_MSupd_Table
If exists ( select 1 from Table where ColID = @pkc1)