Message
From
23/03/2010 08:50:30
To
23/03/2010 08:32:47
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01456345
Message ID:
01456443
Views:
32
>>>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.
>>>
>>>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.