Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO and Data Integrity Checks
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
ADO and Data Integrity Checks
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01209224
Message ID:
01209224
Views:
64
Hi all, I've a table with several check constraints and I'd like to know if there's a way to know exactly what constraint was broken (if that's the case). For example If I have CK_CreditLimit Constraint where the ammount for the field must be >=0, if I try to insert a negative value the constraint is triggered but how can I know back in my Data Layer that this specific check was broken.

I'm using ADO to connect to the database.

TIA,

Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Next
Reply
Map
View

Click here to load this message in the networking platform