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 |
|
jugo
Starting Member
4 Posts |
 Posted - 2004-11-02 : 06:07:47
|
| How i can catch error string that server returns?Not to get just error number and to see from sysmessages in master DB but to get whole string.Example: error:547in sysmesages:"%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls."whole error string:"DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_Ishod_na_Bolesta_Dijagnoza'. The conflict occurred in database 'Ordinacija2004', table 'Ishod_na_Bolesta', column 'Dijagnoza_ID'.The statement has been terminated." |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
To catch string errors in SQL