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-11-26 : 09:17:21
|
| Yoshi writes "Hello. Im using SQL server 7.0 with latest service pack patched. When executing command such as "Restore Log..." in stored procedure, it returns two error message by executing one command (in this case "Restore Log"). Using @@Error, you can only get a information of last error, not the 1st one. In v6.5, you could use syslogs table but not version 7.0.How can you trap the 1st error when one commnad returns more than 2 errors in stored procedue? Thank you in advance. Yoshi" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
RE: Error trapping - Restore Log 