Shawn,

I 'm not familiar with replication, but the message is for an attempted
infringement of a nulls not allowed constraint. This constraint is fairly
usual on primary key columns. Are you sure it's not a Pub message? Else
could the constraint be set on Sub but not on Pub?

Charles

> -----Original Message-----
> From: Shawn Smith [SMTP:[Email Address Removed] Sent: Monday, October 21, 2002 5:39 PM
> To: LazyDBA.com Discussion
> Subject: RE: Transactional Replication Problem
>
> Yes.
>
> -----Original Message-----
> From: Luís Manuel Martins Ganhão [mailto:luis.[Email Address Removed]
> Sent: Monday, October 21, 2002 11:29 AM
> To: 'Shawn Smith'; LazyDBA.com Discussion
> Subject: RE: Transactional Replication Problem
>
>
> Are all columns being replicated?
>
> Luís Manuel Martins Ganhão
> Novabase
> Serviços de Valor Acrescentado
> DBA Oracle Certified Professional 8i
>
> Av. Engº Duarte Pacheco, Torre 1 - 9º
> 1099-078 Lisboa
> Tel: 351213836300
> http://novabase.pt
>
> CONFIDENCIALIDADE: Este e-mail é confidencial e apenas pode ser lido,
> copiado ou utilizado pelo destinatário. Se o recebeu por engano, por favor
> contacte o remetente através de e-mail ou pelo telefone + 351 21 383 63
> 00.
> Agradecemos ainda que apague este e-mail e não divulgue o respectivo
> conteúdo.
>
> CONFIDENTIALITY: This e-mail is confidential and may be privileged. It may
> be read, copied and used only by the intended recipient. If you have
> received it in error, please contact the sender immediately by return
> e-mail
> or by phoning + 351 21 383 63 00. Then please delete this e-mail and do
> not
> disclose its contents to any person.
>
>
> -----Original Message-----
> From: Shawn Smith [mailto:[Email Address Removed] Sent: segunda-feira, 21 de Outubro de 2002 17:27
> To: LazyDBA.com Discussion
> Subject: Transactional Replication Problem
>
>
> Why in Transactional Replication would I receive the error:
>
> Cannot insert the value NULL into column 'InvoiceItemNumber', table
> 'Newsline2.dbo.dbo_HomeInvoiceDetail'; column does not allow nulls. INSERT
> fails.
>
> When 'InvoiceItemNumber' is a Primary Key column on both Pub and Sub.
>
> Help.
>
> Shawn Smith
> Database Administrator
> Fort Worth Star-Telegram
> 817-390-7094
> 817-291-5240 cell
> 817-667-2757 pager
> [Email Address Removed]
>
>
> ----------
> This message may contain confidential information or privileged material,
> and is intended only for the individual(s) named. If you are not in the
> named addressee you should not disseminate, distribute or copy this
> e-mail.
> Please notify the sender immediately by e-mail if you have received this
> e-mail by mistake and delete this e-mail from your system.
> E-mail transmission cannot be guaranteed to be secure or error-free as
> information could be intercepted, corrupted, lost, destroyed, arrive late
> or
> incomplete, or contain viruses. The sender therefore does not accept
> liability for any errors or omissions in the contents of this message
> which
> arise as a result of e-mail transmission. If verification is required
> please
> request a hard-copy version.
MS Sql Server LazyDBA home page