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] 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