Message
From
23/03/2010 08:55:05
To
23/03/2010 08:50:30
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01456345
Message ID:
01456449
Views:
33
>>>>Hi,
>>>>
>>>>I am trying to figure a way to parse an error message when a database constraint fails. The purpose is to make the error message more readable by an average user. I noticed that error message has a section 'constraint "Name_Of_Constraint'. My question is, can I rely that the syntax of error will always have the word 'constraint' before the name of the constraint in double quotes?
>>>
>>>If this is the same error, the error message is always going to be the same.
>>
>>I knew that. I want to know if the structure of error message will be the same regardless of the constraint causing it.
>
>Yes.
Thank you.
>>>>
>>>>I am trying to figure a way to parse an error message when a database constraint fails. The purpose is to make the error message more readable by an average user. I noticed that error message has a section 'constraint "Name_Of_Constraint'. My question is, can I rely that the syntax of error will always have the word 'constraint' before the name of the constraint in double quotes?
>>>
>>>If this is the same error, the error message is always going to be the same.
>>
>>I knew that. I want to know if the structure of error message will be the same regardless of the constraint causing it.
>
>Yes.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham