Groups > comp.databases.ms-sqlserver > #1061

Constraint Errors: What Blew Up?

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Constraint Errors: What Blew Up?
Date	2012-05-21 15:52 -0700
Organization	A noiseless patient Spider
Message-ID	<8khlr79ocjoqh62jhp6ebup8qns4j5d5fp@4ax.com> (permalink)

Cross-posted to 2 groups.

Show all headers | View raw

Dear SQLers:

     If a constraint of some sort is violated, how can I find out
which one?

     Yes, I can parse the error message hoping to find it, but, as
pointed out by Erland, that is subject to the error message being
changed.  I prefer to avoid kludges.

     Is there a function that returns this value?

     Anyone for an error_constraint() function?

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Constraint Errors: What Blew Up? Gene Wirchenko <genew@ocis.net> - 2012-05-21 15:52 -0700
  Re: Constraint Errors: What Blew Up? Erland Sommarskog <esquel@sommarskog.se> - 2012-05-22 07:27 +0000
    Re: Constraint Errors: What Blew Up? Gene Wirchenko <genew@ocis.net> - 2012-05-22 11:12 -0700
      Re: Constraint Errors: What Blew Up? Erland Sommarskog <esquel@sommarskog.se> - 2012-05-22 23:51 +0200
        Re: Constraint Errors: What Blew Up? Gene Wirchenko <genew@ocis.net> - 2012-05-22 17:00 -0700
          Re: Constraint Errors: What Blew Up? Erland Sommarskog <esquel@sommarskog.se> - 2012-05-23 07:21 +0000
            Re: Constraint Errors: What Blew Up? Gene Wirchenko <genew@ocis.net> - 2012-05-23 09:07 -0700
              Re: Constraint Errors: What Blew Up? Erland Sommarskog <esquel@sommarskog.se> - 2012-05-23 23:32 +0200
                Re: Constraint Errors: What Blew Up? Gene Wirchenko <genew@ocis.net> - 2012-05-23 15:03 -0700
                Re: Constraint Errors: What Blew Up? Erland Sommarskog <esquel@sommarskog.se> - 2012-05-24 07:40 +0000

csiph-web