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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-03 : 07:22:40
|
| Alison writes "Is it possible to interrogate the SQL generated messages from within a sproc?? ie; if a Foriegn key(or check constraint) is violated, is it possible to pick up,from the error message, which one has been violated?? as both exceptions return 547 error number which does not distinguish between FK or CC error." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-04-03 : 07:56:42
|
| sort ofseewww.nigelrivett.comspFormatOutputBuffer Retrieve a sql server error message==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Interrogating error message from within a sproc