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

Constraint Errors: What Blew Up?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Constraint Errors: What Blew Up?
Date	Mon, 21 May 2012 15:52:41 -0700
Organization	A noiseless patient Spider
Lines	16
Message-ID	<8khlr79ocjoqh62jhp6ebup8qns4j5d5fp@4ax.com> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Info	mx04.eternal-september.org; posting-host="wKah3EH8kutwAOV6+9FiEQ"; logging-data="7045"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+DuBFdblr6kmf5lZV6ByuPSyBzWsapuFg="
X-Newsreader	Forte Agent 4.2/32.1118
Cancel-Lock	sha1:QrDbY84yqeSFFMKCSp5BrL8ZUS4=
Xref	csiph.com comp.databases.ms-sqlserver:1061

Cross-posted to 2 groups.

Show key headers only | 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