Yes, I checked both of these. I am opening a call to Microsoft. I will post
solution once it is reached.
Shawn
-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed]
Sent: Monday, October 21, 2002 11:43 AM
To: LazyDBA.com Discussion
Subject: RE: Transactional Replication Problem
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page