Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
p2bl
Yak Posting Veteran
54 Posts |
 Posted - 2002-12-30 : 06:13:22
|
| I create some constraints and FK on tables,r there any method to customize the error showed to the user?========================look! |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-12-30 : 13:24:01
|
| Unfortunately the answer is: No. There is no way to change the error message shown to user, unless you wanna use a trigger (BAD IDEA :{!)Sérgio Monteiro |
 |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-12-30 : 15:46:06
|
There is other possibility: You can issue a select on the sysmessages system table (Don't do it if u want support from MS), then update the error messages at your will.But, and this is a BIG BUT, updating the system tables is absolutely not recommended and not supported by Microsoft. If you don't write down the right where filter, you may get yourself in troubles  .Good Luck,Sérgio Monteiro |
|
|
|
|
|
|
customize error