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 - 2005-07-19 : 07:08:10
|
| Priyanka writes "Hi ,I am developing a VB6.0 and SQL server applicationAs per requirement I need to run certain stored Procedures and log all the errors,status of Stored Procedurefor eg :when you run a Stored Procedure in Query Analyser and If a single stored procedure has multiple inserts ,Then in message tab you will see various messages I want to catch those messages .I dont know whether they are stored in Sql in some sys tablesThanks " |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-19 : 07:33:17
|
| I think you can make use of @@Error, @@RowCountMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Catching Messages