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 - 2002-12-23 : 18:15:16
|
| Raghavendra Prasad writes "Hi all, I am using SQL Server 2000. I like to know how to trap the Error messages may be Fatal Error or Non-Fatal errors, Using @@Error it is easy to trap the error code. but it will not give you the actual message.It is also possible to get the Error message from the sysmessage table. select * from master..sysmessages where error = @@Error"Disallowed implicit conversion from data type %ls to data type %ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query."This Message is not clear, it contains "%ls" characters which will be formated while showing the error by SQL Sever.Any one Pls Guide me how to capture the error message & better way of error handling.Thanx in AdvanceRaghavendra Prasad." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Exception handling in SP's 