CK_(table) problem

[SBTBILL]

I'm starting to get a lot of CK_(table) messages. They all involve one table which stores a log of activities. I understand this to be a message that says I am violating a constraint.

Other then the id field which is an auto-numbered index field I do not require data in any fields.

When this happens the table locks up either totally or just enough to block inserts.

Can't seem to find much on this.

One other thing I'll mention is that many of the writes are from within VFP9 service pack 2.

We're using SQL server 2000, but I also have a copy of Server 2005 on my machine.

 

[mrdenny]

If you are getting errors on a check constraint, then you need to verify the data being entered into the column meets the requirements of the check constraint.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[SBTBILL]

The table has one field (ID) that is an entity. The rest are all designed to accept anything or stay null. The fields have no default values or rules

 

[SBTBILL]

The exact structure of the table is
id Int(4) - This is an identity
etype varchar(100) - allow nulls = Yes
edate datetime(8) - allow nulls = yes
order_id int(4) - allow nulls = yes
prempl varchar(50) - allow nulls = yes
prgid varchar(100) - allow nulls = yes
userid int(4) - allow nulls = yes
description varchar(400) - allow nulls = yes

As I said no constraints on the table except for id being an identity.

Problem sometimes occurs if I search the table but often only shows up on inserts.

The function of the table is to keep a record of what process are being used and or to tell where a process stopped working. Processes may be in VB, VFP (FoxPro) or a stored procedure. Most are in FoxPro. Started using the table about 3 years ago. No problems until the last week or 2.

 

[SQLBill]

What are the errors? Are there foreign keys that are causing issues?

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[SBTBILL]

Error is always CK_event_log which I've tracked down as a constraint violation.

No foreign keys.

I tend to believe that the error message is bogus and that it is really a locking issue.

 

[mrdenny]

What are the check constraints on the table?

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog