Professional Web Applications Themes

violation constraint - Microsoft SQL / MS SQL Server

How can I identify the violation constraint name or constraint id in my insert statement. When my constraint is violated I received the code 547 that is a general error to constraint violation, but I need to know what the constraint was violated. Thanks in advance, Marcos...

  1. #1

    Default violation constraint

    How can I identify the violation constraint name or
    constraint id in my insert statement.

    When my constraint is violated I received the code 547
    that is a general error to constraint violation, but I
    need to know what the constraint was violated.

    Thanks in advance,


    Marcos
    marcos Guest

  2. #2

    Default Re: violation constraint

    I know what constraint was violated but I didn't discover
    it with error in my procedure.


     
    violated 
    the operation which 
    sp_helpconstraint. 
    marcos Guest

  3. #3

    Default Re: violation constraint

    Erland has recently written two articles on error handling which may be of
    hepl. Please refer to:
    http://www.algonet.se/~sommar/error-handling-I.html
    http://www.algonet.se/~sommar/error-handling-II.html

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

Similar Threads

  1. Recordset Disappears After an Integrity Constraint Violation
    By gcollazo2@gmail.com in forum Coldfusion Database Access
    Replies: 0
    Last Post: October 19th, 01:57 AM
  2. ODBC Error Code = 23000 (Integrity constraint violation)
    By crystalfish0318 in forum Coldfusion Database Access
    Replies: 6
    Last Post: October 17th, 04:56 PM
  3. Integrity constraint violation
    By sage703 in forum Coldfusion Database Access
    Replies: 3
    Last Post: June 22nd, 08:17 PM
  4. Help Please :- Group Constraint
    By Word of Mouth Productions in forum Macromedia Director Lingo
    Replies: 1
    Last Post: August 24th, 02:36 PM
  5. Best way to create this constraint?
    By Zig Mandel in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 1st, 12:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139