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-05-27 : 11:41:28
|
| sanjay sharma writes "1. i have created stored proc and triggers in sql server 2000 & executing stored proc from vb application.Now problem is, if error is coming in trigger error messageis not coming to vb application.I have already used @@Error in stored procedure.2. What is better way to insert/update master & detail information from Vb application to sql server 2000 (In DNA arcitacture) please provide me better solution " |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-05-27 : 11:50:00
|
| Triggers and errors, how fun... If you are going to use triggers that have the chance of coming up with errors, I'd suggest using @@error to bring up the error inside the trigger and then using an insert statement to store the error in a seperate table. If you can post the script of your procedure, trigger, and the tables.. perhaps we can find a better way of going about it |
 |
|
|
|
|
|
error handling in sql server and give error message to vb application