Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 errors filling up my event logs..

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2009-11-05 : 10:38:11
MS SQL Server 2005...


These two errors are filling up my sql server and Server level application even log??

Cannot add or update Activity record because Account Owner does not exist.

Error: 250071, Severity: 16, State: 1.

The error is associated with a user running a series of inserts like this

INSERT INTO [Activity]([Cust],[Type],[CashTran],[BaseAmt],[BookDate],[RecvPay],[Curr],[FxAmt],[Branch],[Dept],[TranDate],
[Ref],[Account],[ValueDate],[PaymtMethod],[InstrumentQty],[InstrumentPrice]) values(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,getdate(),@11,@12,@13,@14,@15,@16).....

   

- Advertisement -