BUG: Msg 257 When Inserting NULL values by RPC

MORE INFORMATION

   On server A
   -----------
				

   create table rpctestA
   (
   col1 char(2) not null,
   col2 char(2) null
   )

   create proc insert_rpctestA
   @sNo char(2)
   as
   begin
      insert rpctestA
      exec <server B>.pubs.dbo.select_rpctestB @sNo
   end
				

   On server B
   -----------
				

   create table rpctestB
   (
   col1 char(2) not null,
   col2 char(2) null
   )

   insert rpctestB values ('AA', 'BB')

   create proc select_rpctestB
   @sNo char(2)
   as
   begin
       select col1, null
       from rpctestB
       where col1 = @sNo
   end
				

   On server A
   -----------
				

   exec insert_rpctestA